Unanswered: Backup fails with Error Message SQL-DMO (ODBC SQLState:42000) - Need Help !!!
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.
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.