We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SQL maintenance plan to USB drive

Medium Priority
870 Views
Last Modified: 2012-05-11
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

Comment
Watch Question

IT Director
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
EvilPostItIT Director
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Daniel_PLDB Expert/Architect
Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.