Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    4

    Red face Unanswered: Backup fails with Error Message SQL-DMO (ODBC SQLState:42000) - Need Help !!!

    Hi,

    This is my first posting and actually I have big problem which I need to resolve immediately:

    I have a 38 GB Database on my SQL Server which I want to full-backup. Until now backup was created on the same volume where the database resides. But now the volume is out of disk space. So what we did is that we connected an external USB disk drive with 500 GB to the SQL Server and try to backup there.

    But our first and all consecutive backup attemps failed with error SQL-DMO (ODBC SQLState: 42000). It's working fine the first few minutes as we can see that the backup file is continously growing. But then it abruptly aborts with above error message.

    Can anyone figure out why ? Any help is appreciated.

    Thx
    Overlord1970

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    I can't help with the message or backing up onto the usb (never done the latter, don't think I know the former) but can you move stuff off the volume onto the USB drive and backup to the volume as usual?

    Obviously this is not something you are too concerned about now but in future you will need to do some capacity planning and trending so you don't get caught in this situation again.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    ok - 42000 turns out to be generic. What's the full error message? How are you backing up (sqlmaint, via DMO, T-SQL, management studio etc)?

  4. #4
    Join Date
    Nov 2007
    Posts
    4
    OK. Here some more info which might be usefull:
    Database: SQL Server 2000 with SP3
    Backup device: Western Digital External USB Drive 500 GB

  5. #5
    Join Date
    Nov 2007
    Posts
    4
    OK. Backup failed once again. Full error message reads:

    Write on 'F:\New Folder\cpmapp_sun_baymak_full_151107' failed, status = 112, See the SQL Server error log for more details. BACKUP DATABASE is terminating abnormaly.

    I'm using SQL Server Enterprise Manager's SQL Server Backup Utility (with default settings).

    NET HELPMSG 112 indicates that 'There is not enough space on the disk'

    But the USB drive has more than 390 GB free.
    The DB I want to backup is 38 GB big.

  6. #6
    Join Date
    Nov 2007
    Posts
    4

    Problem's Root Cause ?

    I think I found the cause of the problem:

    The Western Digital External USB Storage comes preformatted with FAT32.

    On Western Digital's FAQ Page it says:

    "A file cannot be transferred to a FAT32 partition if the file is larger than 4GB."

    On the other hand, the DB I want to backup is 38 GB big !

    I will reformat the external storage with NTFS and try again.

    I will post an update after trying

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •