SQL maintenance plan to USB drive

Posted on 2011-04-27
Last Modified: 2012-05-11

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.


Question by:Petermcg001
    LVL 16

    Accepted Solution

    Operating system error 112 is "There is not enough space on the disk"

    run this from cmd


    Open in new window

    LVL 16

    Assisted Solution

    The double backslash would be there because \ is an escape character so you can ignore this.
    LVL 14

    Assisted Solution

    You simply could try to issue backup command manually to check:
    BACKUP DATABASE [LiveData] TO  DISK = N'G:\WednesdayUSBBackup\LiveData\LiveData_backup_2011_04_27_114501_5533935.bak'

    Open in new window

    LVL 1

    Author Closing Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    SQL Management Studio Install 11 59
    convert this back to a date? 13 51
    How to script out data export 36 51
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now