 |
| SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
July 8th, 2009, 05:04 AM
|
|
Authorized User
|
|
Join Date: Nov 2005
Posts: 41
Thanks: 6
Thanked 1 Time in 1 Post
|
|
Backup failure
Hi guys
I have started to try backups over a network, after figuring out how to do it.
The MSSQLSERVER service and the SQLAGENT service are both running from the same domain admin NT account.
The code I am using is:
Code:
BACKUP DATABASE DBName TO DISK = '\\ServerName\BUPFolder\DBName.Bak' WITH INIT, NAME = DBName, NOSKIP, STATS=10
I am using the code for about 10 different databases, 4 of them fail after giving me a 100 percent complete message with a 3013 error.
I have created backup devices to back up to and backed up to a file but the same 4 databases fail with the same message.
I have looked through the MSDN pages but they don't seem to help. I have also looked through forums on t'interweb but the main suggestion is to check the user that is running the services mentioned before, which I have already done.
I suppose the questions I need answering are:
Have the backups completed or not?
and
What can I do to stop the 3013 error happening?
Thanks for any assistance offered.
Rob
__________________
Rob Carter
|
|
July 8th, 2009, 05:45 AM
|
|
Authorized User
|
|
Join Date: Nov 2005
Posts: 41
Thanks: 6
Thanked 1 Time in 1 Post
|
|
As an addendum, here is the result of the backup statement:
Quote:
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
50 percent backed up.
60 percent backed up.
70 percent backed up.
80 percent backed up.
90 percent backed up.
Processed 982288 pages for database 'ActivityFiles', file 'ActivityFiles_Data' on file 1.
100 percent backed up.
Processed 1 pages for database 'ActivityFiles', file 'ActivityFiles_Log' on file 1.
Msg 3013, Level 16, State 1, Line 32
BACKUP DATABASE is terminating abnormally.
36 percent backed up.
41 percent backed up.
58 percent backed up.
60 percent backed up.
80 percent backed up.
92 percent backed up.
Processed 328 pages for database 'BedOccupancy', file 'BedOccupancy_Data' on file 1.
100 percent backed up.
Processed 1 pages for database 'BedOccupancy', file 'BedOccupancy_Log' on file 1.
BACKUP DATABASE successfully processed 329 pages in 1.664 seconds (1.615 MB/sec).
11 percent backed up.
20 percent backed up.
31 percent backed up.
40 percent backed up.
52 percent backed up.
60 percent backed up.
72 percent backed up.
81 percent backed up.
92 percent backed up.
Processed 4144 pages for database 'ContractID', file 'ContractID_Data' on file 1.
100 percent backed up.
Processed 1 pages for database 'ContractID', file 'ContractID_Log' on file 1.
BACKUP DATABASE successfully processed 4145 pages in 16.455 seconds (2.063 MB/sec).
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
50 percent backed up.
60 percent backed up.
70 percent backed up.
80 percent backed up.
90 percent backed up.
Processed 121640 pages for database 'flowsheets', file 'flowsheets_Data' on file 1.
100 percent backed up.
Processed 1 pages for database 'flowsheets', file 'flowsheets_Log' on file 1.
Msg 3013, Level 16, State 1, Line 32
BACKUP DATABASE is terminating abnormally.
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
50 percent backed up.
60 percent backed up.
70 percent backed up.
80 percent backed up.
90 percent backed up.
Processed 80216 pages for database 'IM&TIntranetReporting', file 'IM&TIntranetReporting_Data' on file 1.
100 percent backed up.
Processed 1 pages for database 'IM&TIntranetReporting', file 'IM&TIntranetReporting_Log' on file 1.
Msg 3013, Level 16, State 1, Line 32
BACKUP DATABASE is terminating abnormally.
41 percent backed up.
52 percent backed up.
94 percent backed up.
Processed 288 pages for database 'InterProviderTransferDB', file 'InterProviderTransferDB_Data' on file 1.
100 percent backed up.
Processed 1 pages for database 'InterProviderTransferDB', file 'InterProviderTransferDB_Log' on file 1.
BACKUP DATABASE successfully processed 289 pages in 1.277 seconds (1.848 MB/sec).
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
50 percent backed up.
60 percent backed up.
70 percent backed up.
80 percent backed up.
90 percent backed up.
Processed 238720 pages for database 'mpi', file 'MPI_Data' on file 1.
100 percent backed up.
Processed 5 pages for database 'mpi', file 'MPI_Log' on file 1.
Msg 3013, Level 16, State 1, Line 32
BACKUP DATABASE is terminating abnormally.
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
50 percent backed up.
60 percent backed up.
70 percent backed up.
80 percent backed up.
90 percent backed up.
Processed 251216 pages for database 'OCS', file 'OCS_dat' on file 1.
100 percent backed up.
Processed 1 pages for database 'OCS', file 'OCS_log' on file 1.
Msg 3013, Level 16, State 1, Line 32
BACKUP DATABASE is terminating abnormally.
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
50 percent backed up.
60 percent backed up.
70 percent backed up.
80 percent backed up.
90 percent backed up.
Processed 7152 pages for database 'PhysioReferralsDB', file 'PhysioReferralsDB_Data' on file 1.
100 percent backed up.
Processed 1 pages for database 'PhysioReferralsDB', file 'PhysioReferralsDB_Log' on file 1.
BACKUP DATABASE successfully processed 7153 pages in 27.435 seconds (2.135 MB/sec).
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
53 percent backed up.
63 percent backed up.
74 percent backed up.
84 percent backed up.
94 percent backed up.
Processed 1176 pages for database 'Physiotherapy', file 'Physiotherapy_Data' on file 1.
100 percent backed up.
Processed 1 pages for database 'Physiotherapy', file 'Physiotherapy_Log' on file 1.
BACKUP DATABASE successfully processed 1177 pages in 4.698 seconds (2.050 MB/sec).
|
__________________
Rob Carter
|
|
|
