Como saber quien reinicio el SQL

02/07/2008 - 18:15 por Jorge | Informe spam
Hola

Tengo el SQL 2000 instalado en un Windows Server 2003.
El SQL tienen todos los SP.

Me he dado cuenta que hoy a las 02:00am (segun los SQL Server Logs) alguien
reinicio el SQL. Ya que veo en los Logs que a partir de esa hora las bases
de datos se levantan (Starting up database 'NombreBaseDatos')

Se puede saber que usuario o desde donde hicieron eso?

Saludos
JORGE G.

Preguntas similare

Leer las respuestas

#1 Penta
02/07/2008 - 18:25 | Informe spam
Estimado Jorge.
Chequea el EventViewer del S.O.

Atte.
Penta.
Respuesta Responder a este mensaje
#2 Jorge
02/07/2008 - 19:43 | Informe spam
Hola

Ya revise el Visor de Eventos del Windows, y a esa hora +/- se han logeado
al servidor 2 usuarios: un usuario del dominio y otro Anonimo
Revise y encontre que el Servicio del SQL fue bajado, pero no me indica
quien lo hizo o desde que ip, etc

Este es parte del Log del SQL (¿se reiniciaron los servicios del sql, no?)

Date Source Message
2008-07-02 00:59:27.22 server Logging SQL Server messages in file
'f:\DATA_SQL\MSSQL\log\ERRORLOG'.
2008-07-02 00:59:27.22 server Server Process ID is 5676.
2008-07-02 00:59:27.22 server All rights reserved.
2008-07-02 00:59:27.22 server Copyright (C) 1988-2002 Microsoft
Corporation.
2008-07-02 00:59:27.22 server Microsoft SQL Server 2000 - 8.00.2246 (Intel
X86) ...
2008-07-02 00:59:27.24 server SQL Server is starting at priority class
'normal'(4 CPUs detected).
2008-07-02 00:59:27.32 server SQL Server configured for thread mode
processing.
2008-07-02 00:59:27.33 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2008-07-02 00:59:27.43 server Attempting to initialize Distributed
Transaction Coordinator.
2008-07-02 00:59:28.69 spid3 Starting up database 'master'.
2008-07-02 00:59:29.36 spid3 Recovery is checkpointing database 'master'
(1)
2008-07-02 00:59:29.36 spid3 0 transactions rolled back in database
'master' (1).
2008-07-02 00:59:29.54 spid5 Starting up database 'model'.
2008-07-02 00:59:29.54 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2008-07-02 00:59:29.57 spid9 Starting up database 'pubs'.
2008-07-02 00:59:29.57 spid11 Starting up database 'Fingerscan'.
2008-07-02 00:59:29.57 spid10 Starting up database 'Northwind'.
2008-07-02 00:59:29.57 spid8 Starting up database 'msdb'.
2008-07-02 00:59:29.57 spid3 Server name is 'PARACAS'.
2008-07-02 00:59:29.58 server SQL server listening on 127.0.0.1: 1433.
2008-07-02 00:59:29.58 server SQL server listening on 10.7.2.10: 1433.
2008-07-02 00:59:29.60 spid13 Starting up database 'Backs'.
2008-07-02 00:59:29.60 spid12 Starting up database 'Computo'.
2008-07-02 00:59:29.64 spid14 Starting up database 'BMD'.
2008-07-02 00:59:29.66 spid15 Starting up database 'Comunes'.
2008-07-02 00:59:29.71 spid16 Starting up database 'Planilla'.


2008-07-02 00:59:40.82 spid8 Recovery is checkpointing database 'msdb' (4)
2008-07-02 00:59:41.35 spid5 Starting up database 'tempdb'.
2008-07-02 00:59:45.22 spid53 Using 'xpstar.dll' version '2000.80.2246' to
execute extended stored procedure 2008-07-02 00:59:45.22 spid51 Using
'xpstar.dll' version '2000.80.2246' to execute extended stored procedure
2008-07-02 01:00:02.80 spid55 Using 'xplog70.dll' version '2000.80.2039' to
execute extended stored procedure
2008-07-02 01:01:14.05 spid3 SQL global counter collection task is created.
2008-07-02 01:01:14.05 spid3 Recovery complete.


Gracias, saludos
JORGE G.


"Penta" escribió en el mensaje
news:
Estimado Jorge.
Chequea el EventViewer del S.O.

Atte.
Penta.
Respuesta Responder a este mensaje
#3 Penta
02/07/2008 - 21:52 | Informe spam
Estimado Jorge.
Que dice este log ??

2008-07-02 00:59:27.22 server Logging SQL Server messages in file

'f:\DATA_SQL\MSSQL\log\ERRORLOG'.

Atte.
Penta.
Respuesta Responder a este mensaje
#4 Jorge
02/07/2008 - 22:52 | Informe spam
Hola Penta

Dice lo que puse en el correo

Date Source Message
2008-07-02 00:59:27.22 server Logging SQL Server messages in file
'f:\DATA_SQL\MSSQL\log\ERRORLOG'.
2008-07-02 00:59:27.22 server Server Process ID is 5676.
2008-07-02 00:59:27.22 server All rights reserved.
2008-07-02 00:59:27.22 server Copyright (C) 1988-2002 Microsoft
Corporation.
2008-07-02 00:59:27.22 server Microsoft SQL Server 2000 - 8.00.2246 (Intel
X86) ...
2008-07-02 00:59:27.24 server SQL Server is starting at priority class
'normal'(4 CPUs detected).
2008-07-02 00:59:27.32 server SQL Server configured for thread mode
processing.
2008-07-02 00:59:27.33 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2008-07-02 00:59:27.43 server Attempting to initialize Distributed
Transaction Coordinator.
2008-07-02 00:59:28.69 spid3 Starting up database 'master'.
2008-07-02 00:59:29.36 spid3 Recovery is checkpointing database 'master'
(1)
2008-07-02 00:59:29.36 spid3 0 transactions rolled back in database
'master' (1).
2008-07-02 00:59:29.54 spid5 Starting up database 'model'.
2008-07-02 00:59:29.54 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2008-07-02 00:59:29.57 spid9 Starting up database 'pubs'.
2008-07-02 00:59:29.57 spid11 Starting up database 'Fingerscan'.
2008-07-02 00:59:29.57 spid10 Starting up database 'Northwind'.
2008-07-02 00:59:29.57 spid8 Starting up database 'msdb'.
2008-07-02 00:59:29.57 spid3 Server name is 'PARACAS'.
2008-07-02 00:59:29.58 server SQL server listening on 127.0.0.1: 1433.
2008-07-02 00:59:29.58 server SQL server listening on 10.7.2.10: 1433.
2008-07-02 00:59:29.60 spid13 Starting up database 'Backs'.
2008-07-02 00:59:29.60 spid12 Starting up database 'Computo'.
2008-07-02 00:59:29.64 spid14 Starting up database 'BMD'.
...
...
...
2008-07-02 00:59:35.32 spid19 Starting up database 'PPHEMedicos'.
2008-07-02 00:59:35.41 spid12 Starting up database 'ReportServer'.
2008-07-02 00:59:35.50 spid23 102 transactions rolled forward in database
'Servicios' (22).
2008-07-02 00:59:35.57 spid15 Starting up database 'ReportServerTempDB'.
2008-07-02 00:59:35.90 spid9 Starting up database 'dbCrp'.
2008-07-02 00:59:36.22 spid23 0 transactions rolled back in database
'Servicios' (22).
2008-07-02 00:59:36.29 spid23 Recovery is checkpointing database
'Servicios' (22)
2008-07-02 00:59:37.74 spid18 390 transactions rolled forward in database
'HCDigitalCRP' (16).
2008-07-02 00:59:38.24 spid18 0 transactions rolled back in database
'HCDigitalCRP' (16).
2008-07-02 00:59:38.50 spid18 Recovery is checkpointing database
'HCDigitalCRP' (16)
2008-07-02 00:59:39.99 spid13 849 transactions rolled forward in database
'Backs' (9).
2008-07-02 00:59:40.16 spid13 0 transactions rolled back in database
'Backs' (9).
2008-07-02 00:59:40.19 spid13 Recovery is checkpointing database 'Backs'
(9)
2008-07-02 00:59:40.58 spid8 2752 transactions rolled forward in database
'msdb' (4).
2008-07-02 00:59:40.77 spid8 0 transactions rolled back in database 'msdb'
(4).
2008-07-02 00:59:40.82 spid8 Recovery is checkpointing database 'msdb' (4)
2008-07-02 00:59:41.35 spid5 Starting up database 'tempdb'.
2008-07-02 00:59:45.22 spid53 Using 'xpstar.dll' version '2000.80.2246' to
execute extended stored procedure
2008-07-02 00:59:45.22 spid51 Using 'xpstar.dll' version '2000.80.2246' to
execute extended stored procedure
2008-07-02 01:00:02.80 spid55 Using 'xplog70.dll' version '2000.80.2039' to
execute extended stored procedure
2008-07-02 01:01:14.05 spid3 SQL global counter collection task is created.
2008-07-02 01:01:14.05 spid3 Recovery complete.


"Penta" escribió en el mensaje
news:
Estimado Jorge.
Que dice este log ??

2008-07-02 00:59:27.22 server Logging SQL Server messages in file

'f:\DATA_SQL\MSSQL\log\ERRORLOG'.

Atte.
Penta.
Respuesta Responder a este mensaje
#5 Penta
03/07/2008 - 14:45 | Informe spam
Jorge.
Pero revisa el eventviewer del sistema operativo.
En ejecutar eventvwr.msc

Atte.
Penta.
email Siga el debate Respuesta Responder a este mensaje
Ads by Google
Help Hacer una preguntaRespuesta Tengo una respuesta
Search Busqueda sugerida