Jean-Paul natola
jnatola at hotmail.com
Tue Jun 22 08:48:14 CDT 2010
Everyday at 3 am, for the last week or so the sql agent stops
i see theis in the error log:
2010-06-22 00:30:13.17 Backup Database backed up. Database: FCITZ, creation date(time): 2009/06/03(15:49:48), pages dumped: 51851, first LSN: 346:4193:46, last LSN: 346:4212:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\USERS\DATA\IT\Databases\GP_bkp\FCITZ_db_201006220030.BAK'}). This is an informational message only. No user action is required.
2010-06-22 03:00:35.87 spid60 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-06-22 03:00:35.87 spid60 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-06-22 03:00:35.87 spid60 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-06-22 03:00:38.01 spid20s Service Broker manager has shut down.
2010-06-22 03:00:38.88 spid5s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2010-06-22 03:00:38.88 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Jean-Paul Natola
_________________________________________________________________
The New Busy is not the old busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3