Post reply

Backup fails when physical dump is absent. Any Solution for this

  • June 22, 2008 at 11:57 pm

    #123430

    Hi Friends,

    When the physical dump or physical file to which the backup device is pointed is not present or deleted then backup through backup device will fail showing operating system error 2. Do any one knows any solution / workaround to handle this issue like re-initiating backup or somthing....

    Please tell for solutions other than using xp_cmdshell.... Thanks in advance!

    Regards,

    Sakthi 😀

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • June 23, 2008 at 3:33 am

    #832524

    Hi,

    Operating system error = 2(The system cannot find the file specified.).

    Is a very straight forward error message

    Please check if the file path is same , or check if you have sufficient privileges on that folder/ file.

    If the physical dump file or the files associated with it are deleted then you will receive the following error message:

    Msg 3206, Level 16, State 1, Line 1

    The backup device 'XYZ' was not found in sys.backup_devices. To add this backup device, you can use the sp_addumpdevice stored procedure.

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    "More Green More Oxygen !! Plant a tree today"

  • June 23, 2008 at 4:37 am

    #832548

    Hi,

    Thanks for your reply... I understand... but my intention is that even previous bak file is deleted then backup should run without error. .. how to do that... Hope you got it.... 🙂

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • June 23, 2008 at 9:38 am

    #832815

    Either create a new device and take the backup or overwrite the backup file for the same device which is by default.

    example you have create a devices with xyz.bak as a physical file.

    By mistake this bak file is deleted. If you take backup once again to this dump device this will create a backup file.

    Hope I understood ur issue !!!

    "More Green More Oxygen !! Plant a tree today"

  • June 24, 2008 at 9:12 am

    #833378

    Hi,

    Thanks again.. If I take backup manually then your answer is ok.. But how about bakcup running through job... Here is my question... Any error handling can be done to overcome this issue when taking backup through job? Hope my question is clear now 🙂

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply