|
Home > Archive > MS SQL Server > April 2006 > error 17883
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| vadimm 2006-04-07, 3:24 am |
| Hi, ALL
We are getting error 17883
Backup for DB "GBK" was not creating.
19:22 first error.
~ 07:00 users begin to work. Server does not response.
~ 07:13 administrator log in to console.
07:31 server restart. there are no error in error log.
Errorlog:
2006-04-06 19:20:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6750:1, last LSN:
1131478:6786:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:21:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:21:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:22:03.13 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6786:1, last LSN:
1131478:6814:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:22:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:22:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:24:03.21 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6814:1, last LSN:
1131478:6850:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:26:03.12 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6850:1, last LSN:
1131478:6867:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:28:03.20 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6867:1, last LSN:
1131478:6919:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:30:02.70 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:30:04.65 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6919:1, last LSN:
1131478:6962:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:31:08.93 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:31:08.93 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:32:03.18 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:6962:1, last LSN:
1131478:7027:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:34:03.23 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7027:1, last LSN:
1131478:7070:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:36:03.31 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7070:1, last LSN:
1131478:7096:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:37:08.94 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:37:08.94 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:38:03.28 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7096:1, last LSN:
1131478:7127:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:40:02.13 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:40:03.22 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7127:1, last LSN:
1131478:7175:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:42:03.19 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7175:1, last LSN:
1131478:7220:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:44:03.22 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7220:1, last LSN:
1131478:7247:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:44:08.94 server Error: 17883, Severity: 1, State: 0
2006-04-06 19:44:08.94 server The Scheduler 2 appears to be hung. SPID
58, ECID 0, UMS Context 0x07A92978.
2006-04-06 19:46:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7247:1, last LSN:
1131478:7264:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:48:03.24 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7264:1, last LSN:
1131478:7286:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:50:02.13 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
46544:183:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-06 19:50:03.28 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7286:1, last LSN:
1131478:7293:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:52:03.21 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7293:1, last LSN:
1131478:7305:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:54:03.18 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7305:1, last LSN:
1131478:7307:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:56:03.11 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7307:1, last LSN:
1131478:7309:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 19:58:03.10 backup Log backed up: Database: gbk, creation
date(time): 2004/07/24(12:45:40), first LSN: 1131478:7309:1, last LSN:
1131478:7319:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'gbk_log'}).
2006-04-06 22:30:02.74 spid55 Attempting to cycle errorlog.
2006-04-06 22:30:02.83 spid55 Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
2006-04-06 22:30:02.83 spid55 Copyright (C) 1988-2002 Microsoft
Corporation.
2006-04-06 22:30:02.83 spid55 All rights reserved.
2006-04-06 22:30:02.83 spid55 Server Process ID is 636.
2006-04-06 22:30:02.83 spid55 Logging SQL Server messages in file
'd:\mssql2000\MSSQL\
log\ERRORLOG'.
2006-04-06 22:30:02.83 spid55 Errorlog has been reinitialized. See
previous log for older entries.
2006-04-06 22:30:05.14 spid55 DBCC CHECKDB (master) executed by
domain\user found 0 errors and repaired 0 errors.
2006-04-06 22:30:06.81 backup Database backed up: Database: master,
creation date(time): 2006/03/24(20:39:08), pages dumped: 1963, first LSN:
312:455:1, last LSN: 312:457:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: & #123;'master_full'})
.
2006-04-06 22:30:08.88 spid54 DBCC CHECKDB (msdb) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-06 22:30:12.94 backup Database backed up: Database: msdb,
creation date(time): 2000/08/06(01:40:56), pages dumped: 4811, first LSN:
18066:979:1, last LSN: 18066:982:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: {'msdb_full'}).
2006-04-06 22:30:13.89 spid54 DBCC CHECKDB (sqladmin) executed by
domain\user found 0 errors and repaired 0 errors.
2006-04-06 22:30:14.99 backup Database backed up: Database: sqladmin,
creation date(time): 2003/04/21(14:44:13), pages dumped: 258, first LSN:
27404:239:1, last LSN: 27404:241:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK: & #123;'sqladmin_full'
}).
2006-04-06 22:30:17.50 spid55 DBCC CHECKDB (GSM) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-06 22:30:31.42 backup Database log truncated: Database: GSM.
2006-04-06 22:30:33.74 backup Database backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), pages dumped: 3750, first LSN: 46638:361:1,
last LSN: 46638:363:1, number of dump devices: 1, device information:
(FILE=1, TYPE=DISK: {'GSM_full'}).
2006-04-06 22:44:07.73 spid56 DBCC CHECKDB (gbk) executed by domain\user
found 0 errors and repaired 0 errors.
2006-04-07 00:18:47.12 backup Database log truncated: Database: gbk.
2006-04-07 07:14:53.14 server Error: 17883, Severity: 1, State: 0
2006-04-07 07:14:53.14 server The Scheduler 2 appears to be hung. SPID 0,
ECID 0, UMS Context 0x07A86300.
2006-04-07 07:14:56.42 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:361:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:20:03.00 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:30:03.30 backup Log backed up: Database: GSM, creation
date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
46638:368:1, number of dump devices: 1, device information: (FILE=1,
TYPE=DISK: {'GSM_log'}).
2006-04-07 07:31:17.07 backup BACKUP failed to complete the command PRINT
'creating full backup GBK'
backup database [gbk] to [gbk_full] with stats=100, init, skip
2006-04-07 07:31:27.73 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
....
Server restart
| |
| privatenews 2006-04-07, 7:24 am |
| Hello
In essence all this 17883 message tells us is that no context switches were
made on the scheduler. The two things that I can think of are a) a hung
scheduler, or b) a thread that is not properly yielding to the scheduler.
I would suggest opening up a case with PSS since this need memory dump to
find clues to troubleshoot the issue.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, please make sure you have latest service pack installed on the
server.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>Thread-Topic: error 17883
>thread-index: AcZaGCgcfWSWeH5/QoCXiTp9pSJ7YQ==
>X-WBNR-Posting-Host: 212.12.3.11
>From: =?Utf-8?B?dmFkaW1t?= <white@community.nospam>
>Subject: error 17883
>Date: Fri, 7 Apr 2006 00:52:02 -0700
>Lines: 186
>Message-ID: <1961654E-C620-4AFA-BD4A- A731BCA877CE@microso
ft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427204
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>Hi, ALL
>
>We are getting error 17883
>
>Backup for DB "GBK" was not creating.
>
> 19:22 first error.
>~ 07:00 users begin to work. Server does not response.
>~ 07:13 administrator log in to console.
> 07:31 server restart. there are no error in error log.
>
>Errorlog:
>
>2006-04-06 19:20:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6750:1, last LSN:
>1131478:6786:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:21:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:21:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:22:03.13 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6786:1, last LSN:
>1131478:6814:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:22:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:22:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:24:03.21 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6814:1, last LSN:
>1131478:6850:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:26:03.12 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6850:1, last LSN:
>1131478:6867:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:28:03.20 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6867:1, last LSN:
>1131478:6919:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:30:02.70 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:30:04.65 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6919:1, last LSN:
>1131478:6962:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:31:08.93 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:31:08.93 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:32:03.18 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:6962:1, last LSN:
>1131478:7027:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:34:03.23 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7027:1, last LSN:
>1131478:7070:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:36:03.31 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7070:1, last LSN:
>1131478:7096:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:37:08.94 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:37:08.94 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:38:03.28 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7096:1, last LSN:
>1131478:7127:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:40:02.13 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:40:03.22 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7127:1, last LSN:
>1131478:7175:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:42:03.19 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7175:1, last LSN:
>1131478:7220:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:44:03.22 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7220:1, last LSN:
>1131478:7247:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:44:08.94 server Error: 17883, Severity: 1, State: 0
>2006-04-06 19:44:08.94 server The Scheduler 2 appears to be hung. SPID
>58, ECID 0, UMS Context 0x07A92978.
>2006-04-06 19:46:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7247:1, last LSN:
>1131478:7264:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:48:03.24 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7264:1, last LSN:
>1131478:7286:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:50:02.13 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46544:183:1, last LSN:
>46544:183:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-06 19:50:03.28 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7286:1, last LSN:
>1131478:7293:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:52:03.21 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7293:1, last LSN:
>1131478:7305:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:54:03.18 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7305:1, last LSN:
>1131478:7307:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:56:03.11 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7307:1, last LSN:
>1131478:7309:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 19:58:03.10 backup Log backed up: Database: gbk, creation
>date(time): 2004/07/24(12:45:40), first LSN: 1131478:7309:1, last LSN:
>1131478:7319:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'gbk_log'}).
>2006-04-06 22:30:02.74 spid55 Attempting to cycle errorlog.
>2006-04-06 22:30:02.83 spid55 Microsoft SQL Server 2000 - 8.00.760
>(Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
>
>2006-04-06 22:30:02.83 spid55 Copyright (C) 1988-2002 Microsoft
>Corporation.
>2006-04-06 22:30:02.83 spid55 All rights reserved.
>2006-04-06 22:30:02.83 spid55 Server Process ID is 636.
>2006-04-06 22:30:02.83 spid55 Logging SQL Server messages in file
> 'd:\mssql2000\MSSQL\
log\ERRORLOG'.
>2006-04-06 22:30:02.83 spid55 Errorlog has been reinitialized. See
>previous log for older entries.
>2006-04-06 22:30:05.14 spid55 DBCC CHECKDB (master) executed by
>domain\user found 0 errors and repaired 0 errors.
>2006-04-06 22:30:06.81 backup Database backed up: Database: master,
>creation date(time): 2006/03/24(20:39:08), pages dumped: 1963, first LSN:
>312:455:1, last LSN: 312:457:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: & #123;'master_full'})
.
>2006-04-06 22:30:08.88 spid54 DBCC CHECKDB (msdb) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-06 22:30:12.94 backup Database backed up: Database: msdb,
>creation date(time): 2000/08/06(01:40:56), pages dumped: 4811, first LSN:
>18066:979:1, last LSN: 18066:982:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: {'msdb_full'}).
>2006-04-06 22:30:13.89 spid54 DBCC CHECKDB (sqladmin) executed by
>domain\user found 0 errors and repaired 0 errors.
>2006-04-06 22:30:14.99 backup Database backed up: Database: sqladmin,
>creation date(time): 2003/04/21(14:44:13), pages dumped: 258, first LSN:
>27404:239:1, last LSN: 27404:241:1, number of dump devices: 1, device
>information: (FILE=1, TYPE=DISK: & #123;'sqladmin_full'
}).
>2006-04-06 22:30:17.50 spid55 DBCC CHECKDB (GSM) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-06 22:30:31.42 backup Database log truncated: Database: GSM.
>2006-04-06 22:30:33.74 backup Database backed up: Database: GSM,
creation
>date(time): 2004/06/05(00:34:40), pages dumped: 3750, first LSN:
46638:361:1,
>last LSN: 46638:363:1, number of dump devices: 1, device information:
>(FILE=1, TYPE=DISK: {'GSM_full'}).
>2006-04-06 22:44:07.73 spid56 DBCC CHECKDB (gbk) executed by
domain\user
>found 0 errors and repaired 0 errors.
>2006-04-07 00:18:47.12 backup Database log truncated: Database: gbk.
>2006-04-07 07:14:53.14 server Error: 17883, Severity: 1, State: 0
>2006-04-07 07:14:53.14 server The Scheduler 2 appears to be hung. SPID
0,
>ECID 0, UMS Context 0x07A86300.
>2006-04-07 07:14:56.42 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:361:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:20:03.00 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:30:03.30 backup Log backed up: Database: GSM, creation
>date(time): 2004/06/05(00:34:40), first LSN: 46638:368:1, last LSN:
>46638:368:1, number of dump devices: 1, device information: (FILE=1,
>TYPE=DISK: {'GSM_log'}).
>2006-04-07 07:31:17.07 backup BACKUP failed to complete the command
PRINT
>'creating full backup GBK'
>backup database [gbk] to [gbk_full] with stats=100, init, skip
>2006-04-07 07:31:27.73 spid3 SQL Server is terminating due to 'stop'
>request from Service Control Manager.
>...
>Server restart
>
>
|
|
|
|
|