SQL maintenance plan to USB drive
Posted on 2011-04-27
I want to configure a maintenance plan in SQL 2008 studio to backup one database to a USB drive connected to the server as drive G.
I've found that the plan is failing. The error message is:-
Executing the query "BACKUP DATABASE [LiveData] TO DISK = N'G:\\Wednes..." failed with the following error: "A nonrecoverable I/O error occurred on file "G:\\WednesdayUSBBackup\\LiveData\\LiveData_backup_2011_04_27_114501_5533935.bak:" 112(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
One thing which is confusing me is why the error message includes double backslashes in the file path. Is this the problem.
I have a similar plan to an internal drive which is working fine.