June 3, 2014 at 2:07 am
Good morning,
Having yet another issue with backups.
I have created two empty databases in preparation for a new application that is to me installed.
Also in preparation I have set up a maintenance plan to back these two databases up.
When I run the TSQL of the Maintenance plan - I get the following error -
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\mhsmgmt01\SQL BACKUPS\MHSVI-SQL2008A\instance2\Website _Live \Website _Live _backup_2014_06_03_090700_1811584.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
12 percent processed.
21 percent processed.
30 percent processed.
43 percent processed.
51 percent processed.
60 percent processed.
73 percent processed.
82 percent processed.
90 percent processed.
Processed 184 pages for database 'Website _Test', file 'Website _Test' on file 1.
100 percent processed.
Processed 1 pages for database 'Website _Test', file 'Website _Test_log' on file 1.
BACKUP DATABASE successfully processed 185 pages in 0.064 seconds (22.583 MB/sec).
The service account that runs SQL Server and Agent has access to the databases and also has permissions to the location that the backup is being asked to write to.
I'm out of ideas now?
June 3, 2014 at 2:14 am
You have several spaces in the folder structure. Do they actually exist in the folder name?
Copy the folder structure from the code and paste it in the address of an explorer window (and hit enter) to check if it is correct...
June 3, 2014 at 2:32 am
Ahhhh for goodness sake.
Copying and pasting the UNC path would go to the location, so I thought nothing of that.
As you have spotted the database name as a space at the end of the name - so "Website_Live " instead of "Website_Live". Renamed the database and it's now working.
Thanks for pointing out the obvious.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply