February 14, 2008 at 9:45 am
I'm working on trying to setup nightly backups for my SQL servers. Bare with me as I am learning.
I setup a simple full backup each night for my databases using the maintenance plan.
Its as simple as
1.) selected the databases
2.) FULL backup
3.) specified the detination, which is on a second array on the local server
When I came in this morning, it failed. I see this in the Maintenance plan error logs:
Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.Incorrect syntax near '\\'.
Executing the query "EXECUTE master.dbo.xp_create_subdir N'F:\\\\VCDB'
" failed with the following error: "xp_create_subdir() returned error 183, 'Cannot create a file when that file already exists.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I tried deleting the folders and running it again, but no luck.
I even unchecked 'Create a sub-directory for each database'. No luck.
Any suggestions?
Appreciate the help.
February 14, 2008 at 10:07 am
Think I figured it out.
Will stand by to confirm.
February 27, 2008 at 12:13 pm
Delete the previous database backup files and then start the backup job.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply