I am trying to get our Disaster Recovery plan in place here, but I am running into problems trying to backup our SQL 2005 databases.
We are running SBS 2003 R2 Premium, I have installed a 320GB DLT tape drive.
I have installed Yosemite Tapeware v 7.00 SP5C.
I have also installed the tapeware agents for Exchange and SQL.
Running a full backup (with Tapeware) backs-up everything without problems except for the SQL 2005 databases.
The Tapeware log shows the error "932 - Unable to create SQL pipe" for each SQL database.
I followed the Tapeware documentaion to add the ODBC connection for the SQL instance and I believe I have it configured correctly, but I can't find any real documentaion explaining the error except for the following:
"Error Number 932 Unable to create SQL pipe
Description: When attempting to backup or restore, TapeWare was unable to open the transfer pipe. This is normal if the server has rejected the DUMP or LOAD command."
After reading some of these posts, it looks like I could also just scrap the Tapeware SQL agent and have SQL "dump" the data to a file and just have Tapeware backup the file. But I am not sure how to do that.
Either way, I need to get these databases backed up so I can sleep at night!
I am quite inexperienced with SQL.
Any of your expertise would be greatly appreciated.