Networker

[Networker] Unsuccessful saveset in backing up MSSQL database?

2008-11-24 08:24:07
Subject: [Networker] Unsuccessful saveset in backing up MSSQL database?
From: ee01akk <networker-forum AT BACKUPCENTRAL DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Mon, 24 Nov 2008 08:21:36 -0500
Any ideas on why sqlsun is failing its backupset?

NetWorker savegroup: (alert) SQL completed, Total 2 client(s), 1 Failed, 1 
Succeeded. Please see group completion details for more information.

Failed: sqlsun
Succeeded: racsqlpwa

Start time: Mon Nov 17 02:00:00 2008
End time: Mon Nov 17 09:41:34 2008


--- Unsuccessful Save Sets ---

* sqlsun:MSSQL:Empower savegrp: suppressed 18 lines of output.
* sqlsun:MSSQL:Empower 38006 1226887217 5 0 0 3956 368 0 sqlsun nsrsqlsv 3 %s. 
1 24 42 BACKUP DATABASE is terminating abnormally.
* sqlsun:MSSQL:Empower 29282 1226887217 5 0 0 3828 368 0 sqlsun nsrsqlsv 31 
\nBackup/Recover command failed 0
* sqlsun:MSSQL:Empower 53084 1226887217 5 0 0 3828 368 0 sqlsun nsrsqlsv 47 
Processing %s failed, the item will be skipped. 1 0 7 Empower
* sqlsun:MSSQL:Empower 0 1226887217 1 0 0 3828 368 0 sqlsun nsrsqlsv 88 %s%s: 
%-*s%s%s%s %*s %2.2ld:%2.2ld:%2.2ld, %ld-file(s)-processed, 
%ld-file(s)-succeeded 14 0 0 0 6 sqlsun 1 2 23 23 13 MSSQL:Empower 0 7 level= 0 
4 full 0 1 , 1 1 9 0 4 0 KB 2 1 0 2 1 0 2 1 3 2 1 1 2 1 0
* sqlsun:MSSQL:Empower 43709 1226887218 1 0 0 3828 368 0 sqlsun nsrsqlsv 13 
Stop time: %s 1 35 25 Mon Nov 17 02:00:18 2008
* sqlsun:MSSQL:Empower 


--- Successful Save Sets ---

* racsqlpwa:MSSQL$PERSONNEL:Empower savegrp: suppressed 7 lines of output.
* racsqlpwa:MSSQL$PERSONNEL:Empower 37994 1226887209 1 0 0 632 512 0 RACSQLPWA 
nsrsqlsv 16 Backing up %s... 1 0 7 Empower
* racsqlpwa:MSSQL$PERSONNEL:Empower 4690 1226887209 1 0 0 632 512 0 RACSQLPWA 
nsrsqlsv 2 %s 1 0 115 BACKUP database [Empower] TO 
virtual_device='Legato#21228678-a952-4cac-b883-fcceeedb6051' WITH 
name=N'LegatoNWMSQL'
* racsqlpwa:MSSQL$PERSONNEL:Empower 53085 1226914845 1 0 0 632 512 0 RACSQLPWA 
nsrsqlsv 27 Backing up of %s succeeded. 1 0 7 Empower
* racsqlpwa:MSSQL$PERSONNEL:Empower 0 1226914845 1 0 0 632 512 0 RACSQLPWA 
nsrsqlsv 54 %s%s: %-*s%s%s%s %*s %2.2ld:%2.2ld:%2.2ld %6ld file(s) 13 0 0 0 9 
racsqlpwa 1 2 20 23 23 MSSQL$PERSONNEL:Empower 0 7 level= 0 4 full 0 1 , 1 1 6 
0 5 10 GB 2 1 7 2 2 40 2 2 39 2 1 1
* racsqlpwa:MSSQL$PERSONNEL:Empower 43709 1226914855 1 0 0 632 512 0 RACSQLPWA 
nsrsqlsv 13 Stop time: %s 1 35 25 Mon Nov 17 09:40:55 2008
* racsqlpwa:MSSQL$PERSONNEL:Empower 
  racbackup.raclub.local: index:racsqlpwa level=full, 69 MB 00:00:31 342 files

* sqlsun:MSSQL:insight_db_v31 savegrp: suppressed 8 lines of output.
* sqlsun:MSSQL:insight_db_v31 4690 1226887210 1 0 0 3444 1836 0 sqlsun nsrsqlsv 
2 %s 1 0 122 BACKUP database [INSIGHT_DB_V31] TO 
virtual_device='Legato#7d0555c2-5044-45ff-b61f-12e334d577cd' WITH 
name=N'LegatoNWMSQL'
* sqlsun:MSSQL:insight_db_v31 53085 1226887488 1 0 0 3444 1836 0 sqlsun 
nsrsqlsv 27 Backing up of %s succeeded. 1 0 14 INSIGHT_DB_V31
* sqlsun:MSSQL:insight_db_v31 0 1226887488 1 0 0 3444 1836 0 sqlsun nsrsqlsv 54 
%s%s: %-*s%s%s%s %*s %2.2ld:%2.2ld:%2.2ld %6ld file(s) 13 0 0 0 6 sqlsun 1 2 23 
23 20 MSSQL:insight_db_v31 0 7 level= 0 4 full 0 1 , 1 1 9 0 6 281 MB 2 1 0 2 1 
4 2 2 42 2 1 1
* sqlsun:MSSQL:insight_db_v31 29067 1226887491 1 0 0 3444 1836 0 sqlsun 
nsrsqlsv 113 Skip building named instance directory because there are no named 
instances installed or running on this machine. 0
* sqlsun:MSSQL:insight_db_v31 43709 1226887494 1 0 0 3444 1836 0 sqlsun 
nsrsqlsv 13 Stop time: %s 1 35 25 Mon Nov 17 02:04:54 2008
* sqlsun:MSSQL:insight_db_v31 
* sqlsun:MSSQL:SUNDB savegrp: suppressed 7 lines of output.
* sqlsun:MSSQL:SUNDB 37994 1226887210 1 0 0 3760 3840 0 sqlsun nsrsqlsv 16 
Backing up %s... 1 0 5 SUNDB
* sqlsun:MSSQL:SUNDB 4690 1226887210 1 0 0 3760 3840 0 sqlsun nsrsqlsv 2 %s 1 0 
113 BACKUP database [SUNDB] TO 
virtual_device='Legato#4ca4b9de-f31b-4bcf-813a-7c7f0df72b0e' WITH 
name=N'LegatoNWMSQL'
* sqlsun:MSSQL:SUNDB 53085 1226889482 1 0 0 3760 3840 0 sqlsun nsrsqlsv 27 
Backing up of %s succeeded. 1 0 5 SUNDB
* sqlsun:MSSQL:SUNDB 0 1226889482 1 0 0 3760 3840 0 sqlsun nsrsqlsv 54 %s%s: 
%-*s%s%s%s %*s %2.2ld:%2.2ld:%2.2ld %6ld file(s) 13 0 0 0 6 sqlsun 1 2 23 23 11 
MSSQL:SUNDB 0 7 level= 0 4 full 0 1 , 1 1 9 0 7 2956 MB 2 1 0 2 2 37 2 2 56 2 1 
1
* sqlsun:MSSQL:SUNDB 29067 1226889485 1 0 0 3760 3840 0 sqlsun nsrsqlsv 113 
Skip building named instance directory because there are no named instances 
installed or running on this machine. 0
* sqlsun:MSSQL:SUNDB 43709 1226889487 1 0 0 3760 3840 0 sqlsun nsrsqlsv 13 Stop 
time: %s 1 35 25 Mon Nov 17 02:38:07 2008
* sqlsun:MSSQL:SUNDB 
* sqlsun:MSSQL:patables savegrp: suppressed 8 lines of output.
* sqlsun:MSSQL:patables 4690 1226887210 1 0 0 3824 3664 0 sqlsun nsrsqlsv 2 %s 
1 0 116 BACKUP database [PATABLES] TO 
virtual_device='Legato#db43f039-6c4f-4395-ae98-166d94980d79' WITH 
name=N'LegatoNWMSQL'
* sqlsun:MSSQL:patables 53085 1226887267 1 0 0 3824 3664 0 sqlsun nsrsqlsv 27 
Backing up of %s succeeded. 1 0 8 PATABLES
* sqlsun:MSSQL:patables 0 1226887267 1 0 0 3824 3664 0 sqlsun nsrsqlsv 54 %s%s: 
%-*s%s%s%s %*s %2.2ld:%2.2ld:%2.2ld %6ld file(s) 13 0 0 0 6 sqlsun 1 2 23 23 14 
MSSQL:patables 0 7 level= 0 4 full 0 1 , 1 1 9 0 5 48 MB 2 1 0 2 1 1 2 1 1 2 1 1
* sqlsun:MSSQL:patables 29067 1226887270 1 0 0 3824 3664 0 sqlsun nsrsqlsv 113 
Skip building named instance directory because there are no named instances 
installed or running on this machine. 0
* sqlsun:MSSQL:patables 43709 1226887272 1 0 0 3824 3664 0 sqlsun nsrsqlsv 13 
Stop time: %s 1 35 25 Mon Nov 17 02:01:12 2008
* sqlsun:MSSQL:patables 
  racbackup.raclub.local: index:sqlsun level=full, 33 MB 00:00:30 589 files
   
 
Networker client OS and versions:

Operadb is Windows 2000 SP 2 Network Client Version 7.4 SP2 Build 431
SQLSun is Windows 2000 SP4 Network Client Version 7.4 SP2 Build 431
RACBackup Windows 2000 SP4 Network Server Version 7.4 SP2 Build 431

Any ideas ??

+----------------------------------------------------------------------
|This was sent by ee01akk AT hotmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>
  • [Networker] Unsuccessful saveset in backing up MSSQL database?, ee01akk <=