Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Como saber quien reinicio el SQL

247 views
Skip to first unread message

Jorge

unread,
Jul 2, 2008, 12:15:36 PM7/2/08
to
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.


Penta

unread,
Jul 2, 2008, 12:25:27 PM7/2/08
to
Estimado Jorge.
Chequea el EventViewer del S.O.

Atte.
Penta.

Jorge

unread,
Jul 2, 2008, 1:43:16 PM7/2/08
to
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" <crist...@gmail.com> escribió en el mensaje
news:467669cd-aa0e-4b36...@m73g2000hsh.googlegroups.com...

Penta

unread,
Jul 2, 2008, 3:52:13 PM7/2/08
to
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.

Jorge

unread,
Jul 2, 2008, 4:52:48 PM7/2/08
to
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: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" <crist...@gmail.com> escribió en el mensaje

news:617238c2-2481-41b9...@m44g2000hsc.googlegroups.com...

Penta

unread,
Jul 3, 2008, 8:45:32 AM7/3/08
to
Jorge.
Pero revisa el eventviewer del sistema operativo.
En ejecutar eventvwr.msc

Atte.
Penta.


0 new messages