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.
Dig Deeper on SAP Basis
Related Q&A from Giovanni Davila
Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila. Continue Reading
Learn fundamentals of transport management and STMS from Basis guru Giovanni Davila in this expert tip. Continue Reading
Giovanni Davila, Basis expert, provides advice on how to copy all SAP users from one system to another in this tip. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.