Post reply

BACKUP DATABASE keeps failing

  • August 17, 2009 at 3:02 am

    #385195

    I have a maintenance plan (SQL 2005) that has been backing up over 20 DB's to a location on the local drive - with a subfolder per DB.

    Last week I created a new DB and confirmed it was added to the maintenance plan for backup.

    But it keeps failing on this new DB with the following error (from Maintenance plan history):

    BACKUP DATABASE DB_name_here

    TO DISK = N'path_here\DB_name_here _backup_200908171047.bak'

    failed with the following error:

    Cannot open backup device path_here\DB_name_here _backup_200908171047.bak'

    Operating system error 3(The system cannot find the path specified.).

    The other DB's are still being backed up - it is just this new DB not being backed up

  • August 17, 2009 at 6:48 am

    #1040139

    Add the subfolder and see if it helps.

    Clement

  • August 17, 2009 at 8:02 am

    #1040192

    I found my problem - there was a space at the end of the DB name - silly me.

    removed it - all worked fine

    thanks

Viewing 3 posts - 1 through 2 (of 2 total)

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