I have many databases that I can backup just fine on my
SQL Server. However, there is one database that I cannot
backup without the following message:
"backup database is terminating abnormally".
The strange thing is that the database really does get
backed up despite the messages; I've even done restores
from the backup.
When I checked the event log, there are two errors.
ONE:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 8/25/2003
Time: 08:23:59
User: MARIN\aaronosheroff
Computer: IS-DBS2
Description:
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup
device '\\Ivcserv1
\SqlServerBackups\HP_STUREC_MCC_CES.BAK'. Operating system
error 64(The specified network name is no longer
available.).
Data:
0000: 22 47 00 00 10 00 00 00 "G.....
0008: 08 00 00 00 49 00 53 00 ...I.S.
0010: 2d 00 44 00 42 00 53 00 -.D.B.S.
0018: 32 00 00 00 00 00 00 00 2......
and TWO:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 8/25/2003
Time: 08:23:59
User: MARIN\aaronosheroff
Computer: IS-DBS2
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE
[HP_STUREC_MCC_CES] TO DISK = N'\\Ivcserv1
\SqlServerBackups\HP_STUREC_MCC_CES.BAK' WITH INIT ,
NOUNLOAD , NAME = N'HP_STUREC_MCC_CES backup', NOSKIP ,
STATS = 10, NOFORMAT
Data:
0000: e1 0b 00 00 10 00 00 00 ......
0008: 08 00 00 00 49 00 53 00 ...I.S.
0010: 2d 00 44 00 42 00 53 00 -.D.B.S.
0018: 32 00 00 00 00 00 00 00 2......
Can someone help me out here? Thanks...Originally posted by DrummerCA33
I have many databases that I can backup just fine on my
SQL Server. However, there is one database that I cannot
backup without the following message:
"backup database is terminating abnormally".
The strange thing is that the database really does get
backed up despite the messages; I've even done restores
from the backup.
When I checked the event log, there are two errors.
ONE:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 8/25/2003
Time: 08:23:59
User: MARIN\aaronosheroff
Computer: IS-DBS2
Description:
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup
device '\\Ivcserv1
\SqlServerBackups\HP_STUREC_MCC_CES.BAK'. Operating system
error 64(The specified network name is no longer
available.).
Data:
0000: 22 47 00 00 10 00 00 00 "G.....
0008: 08 00 00 00 49 00 53 00 ...I.S.
0010: 2d 00 44 00 42 00 53 00 -.D.B.S.
0018: 32 00 00 00 00 00 00 00 2......
and TWO:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 8/25/2003
Time: 08:23:59
User: MARIN\aaronosheroff
Computer: IS-DBS2
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE
[HP_STUREC_MCC_CES] TO DISK = N'\\Ivcserv1
\SqlServerBackups\HP_STUREC_MCC_CES.BAK' WITH INIT ,
NOUNLOAD , NAME = N'HP_STUREC_MCC_CES backup', NOSKIP ,
STATS = 10, NOFORMAT
Data:
0000: e1 0b 00 00 10 00 00 00 ......
0008: 08 00 00 00 49 00 53 00 ...I.S.
0010: 2d 00 44 00 42 00 53 00 -.D.B.S.
0018: 32 00 00 00 00 00 00 00 2......
Can someone help me out here? Thanks...
Come on...anyone?|||u sure that it is a current backup? Not a previous backup...
mike|||Do you run your backup with the agent? Did you try to just paste the command into QA and see how it does it? Also, check with your sysadmin or whoever is responsible for windows logins, and see if he/she can confirm there is no implied policy that somehow affects this particular share.|||Originally posted by wukie
u sure that it is a current backup? Not a previous backup...
mike
Could you please clarify what you're asking? Thanks for the post!|||Originally posted by rdjabarov
Do you run your backup with the agent? Did you try to just paste the command into QA and see how it does it? Also, check with your sysadmin or whoever is responsible for windows logins, and see if he/she can confirm there is no implied policy that somehow affects this particular share.
Thanks for the post. I've run it with the agent; cut & pasted it into QA, it doesn't matter. The network share is just fine; it works with the other databases. The only difference between this and the other databases is that this one is about 2.2 gigs, the others are smaller.|||if you delete the file on disk and then run the backup, does the bu still produce a usable backup file?
Mike|||Originally posted by wukie
if you delete the file on disk and then run the backup, does the bu still produce a usable backup file?
Mike
Yes. A usuable copy is made. It's just that the backup always "fails" with the error messages I've described.|||OK...some kind people have found the solution. By backing up to the LOCAL DRIVE (D:) it complete without the error message. Then, I guess I can just copy the backup file the the share as part of a script or something.
Thanks everyone who responded!!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment