Q
Problem solve Get help with specific problems with your technologies, process and projects.

IBM DLT autoloader trouble

Our spanned backups using MSSQL7.0 R/3 release 3.1H Database has grown beyond the capacity of our DLT. We have...

purchased an IBM DLT autoloader but when the first tape reaches its end (using scheduled backup with SQL Agent), we get an error stating that Tape in drive may have changed and the backup stops. We have tried several options (INIT, NOINIT, SKIP,NOSKIP) but until now we only managed to make it work once. We tried a second time using exactly the same backup options, but it keeps failing with the same error. What could we be doing wrong?


How large is this database? Have you looked into backing up just certain files? Do you back up to disk at all? Is there any space to do this?

Take a look at "Data File backups" in the Books Online that comes with SQL Server.


This was last published in October 2001

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close