August 17, 2009 at 3:02 am
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
Add the subfolder and see if it helps.
Clement
August 17, 2009 at 8:02 am
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