Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2003
    Posts
    13

    Unhappy Unanswered: Backup Database Fails with "backup database is terminating abnormally" message

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

  2. #2
    Join Date
    Aug 2003
    Posts
    13

    Re: Backup Database Fails with "backup database is terminating abnormally" message

    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?

  3. #3
    Join Date
    May 2003
    Location
    California Coast
    Posts
    72
    u sure that it is a current backup? Not a previous backup...

    mike

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    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.

  5. #5
    Join Date
    Aug 2003
    Posts
    13
    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!

  6. #6
    Join Date
    Aug 2003
    Posts
    13
    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.

  7. #7
    Join Date
    May 2003
    Location
    California Coast
    Posts
    72
    if you delete the file on disk and then run the backup, does the bu still produce a usable backup file?

    Mike

  8. #8
    Join Date
    Aug 2003
    Posts
    13
    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.

  9. #9
    Join Date
    Aug 2003
    Posts
    13
    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!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •