May 26, 2003 at 2:44 am
i have multiple database to back up on tape. but only 1 database succeeded back up to tape, the rest will have this error in sql server logs "Backup can not be performed on this database. This sub task is ignored"
May 27, 2003 at 5:51 am
Which database(s) is/are failing and what type of backup are you attempting to do?
-SQLBill
May 27, 2003 at 6:44 am
Also, check the Windows Event Logs. Many times backups write more information there.
June 25, 2003 at 9:37 pm
Currently, I backup 2 database to tape at different time. The second database backup to tape is successful but the first one failed with the following error.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\.\Tape0'. Device error or device off-line. See the SQL Server error log for more details.
Anyone can help me?
June 26, 2003 at 3:50 am
Again check the Windows Event Viewer logs.
For example I get the same message you see when the tape needs to be cleaned. Checking in the Event VIewer logs give me a more prcise error message. This is dependant on the driver used but I haven't seen any that give bogus messages.
Check there and see if any message about tape at that time appears.
June 26, 2003 at 6:46 am
If this is SQL 7.
I had the same problems in the past.
You can only backup to tape one database at a time.
Have to tried backing up to disk then backup all .bak file to tape this may work.
Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply