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.

Could you please clarify what you're asking? Thanks for the post!

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

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!!