Backup Fails When DB is Large (2.2 gigs)

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 =3D N'\\Ivcserv1
\SqlServerBackups\HP_STUREC_MCC_CES.BAK' WITH INIT , NOUNLOAD , NAME =3D N'HP_STUREC_MCC_CES backup', NOSKIP , STATS =3D 10, NOFORMAT Data:
0000: e1 0b 00 00 10 00 00 00 =E1......
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...
.Thanks for the post, but this is not the problem...
>--Original Message--
>does the network share exist? See if you can run
>BACKUP DATABASE [HP_STUREC_MCC_CES] TO DISK =3D 'c:\mybakup.bak'
>"Aaron" <aaron.osheroff@.marin.cc.ca.us> wrote in message
>news:064101c36b45$8a492230$a101280a@.phx.gbl...
>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 =3D N'\\Ivcserv1
>\SqlServerBackups\HP_STUREC_MCC_CES.BAK' WITH INIT ,
>NOUNLOAD , NAME =3D N'HP_STUREC_MCC_CES backup', NOSKIP ,
>STATS =3D 10, NOFORMAT
>Data:
>0000: e1 0b 00 00 10 00 00 00 =E1......
>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...
>
>
>..
>
>.
>|||normally this seems to be a network issue.
>--Original Message--
>Thanks for the post, but this is not the problem...
>
>>--Original Message--
>>does the network share exist? See if you can run
>>BACKUP DATABASE [HP_STUREC_MCC_CES] TO DISK >=3D 'c:\mybakup.bak'
>>"Aaron" <aaron.osheroff@.marin.cc.ca.us> wrote in message
>>news:064101c36b45$8a492230$a101280a@.phx.gbl...
>>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 =3D N'\\Ivcserv1
>>\SqlServerBackups\HP_STUREC_MCC_CES.BAK' WITH INIT ,
>>NOUNLOAD , NAME =3D N'HP_STUREC_MCC_CES backup', NOSKIP ,
>>STATS =3D 10, NOFORMAT
>>Data:
>>0000: e1 0b 00 00 10 00 00 00 =E1......
>>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...
>>
>>
>>..
>>
>>.
>.
>|||yeah, I missed the fact that you can backup even SQL shows error messages.
"Aaron" <aaron.osheroff@.marin.cc.ca.us> wrote in message
news:06fb01c36b4e$3bde2060$a101280a@.phx.gbl...
Thanks for the post, but this is not the problem...
>--Original Message--
>does the network share exist? See if you can run
>BACKUP DATABASE [HP_STUREC_MCC_CES] TO DISK
= 'c:\mybakup.bak'
>"Aaron" <aaron.osheroff@.marin.cc.ca.us> wrote in message
>news:064101c36b45$8a492230$a101280a@.phx.gbl...
>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...
>
>
>..
>
>.
>|||Thank you!!! This works!
>--Original Message--
>If it works locally then would an option not be to back up locally and then
>move the backup file to the network share ? This would be quicker and
>probably less error prone. This is assuming you have the required local
>diskspace.
>-- >HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"Aaron" <aaron.osheroff@.marin.cc.ca.us> wrote in message
>news:064101c36b45$8a492230$a101280a@.phx.gbl...
>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 =3D N'\\Ivcserv1
>\SqlServerBackups\HP_STUREC_MCC_CES.BAK' WITH INIT ,
>NOUNLOAD , NAME =3D N'HP_STUREC_MCC_CES backup', NOSKIP ,
>STATS =3D 10, NOFORMAT
>Data:
>0000: e1 0b 00 00 10 00 00 00 =E1......
>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...
>
>
>..
>
>.
>|||The company were I work is ecperiencing the exact same error message
backing up our 30GB SQL Database. Backing up locally then transferring
to a network drive is not an option. Has anyone successfully resolved
this problem.
Thank you.
Posted via http://dbforums.com|||Amang,
I dont know if its a problem with my newsreader, but I dont see any error
description or the original post contents.What is the error that you are
facing?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"amang" <member38559@.dbforums.com> wrote in message
news:3343101.1063031172@.dbforums.com...
> The company were I work is ecperiencing the exact same error message
> backing up our 30GB SQL Database. Backing up locally then transferring
> to a network drive is not an option. Has anyone successfully resolved
> this problem.
>
> Thank you.
>
> --
> Posted via http://dbforums.com