asked on

SQL maintenance plan to USB drive

Hello

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.

Thanks

ASKER CERTIFIED SOLUTION

EvilPostIt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

EvilPostIt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Daniel_PL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Petermcg001

ASKER

Sorry, really red face here!

I discovered that the USB drives had been supplied as FAT32 and therefore couldn't support the file size needed.

Reformatted them NTFS and it works fine.