Cannot able to take DB Backup to Tape Drive

[Former Member]

Hi,

I cannot take DB backup from SQL server and also from SAP too. Its getting failure.

I changed the Tape drive and Tape also.

SAP DB13 error msg is below:

Executed as user: NT AUTHORITY\SYSTEM. ...ontact your system administrator. [SQLSTATE 01000] (Message 2528) Processed 10575360 pages for database 'APP', file 'APPDATA1' on file 1. [SQLSTATE 01000] (Message 4035) Processed 6256640 pages for database 'APP', file 'APPDATA2' on file 1. [SQLSTATE 01000] (Message 4035) Processed 6667936 pages for database 'APP', file 'APPDATA3' on file 1. [SQLSTATE 01000] (Message 4035) Processed 2857 pages for database 'APP', file 'APPLOG1' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 23502793 pages in 2029.133 seconds (94.885 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 1568 pages for database 'master', file 'master' on file 2. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'master', file 'mastlog' on file 2. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 1569 pages in 8.052 seconds (1.595MB/sec). [SQLSTATE 01000] (Message 3014) Processed 3016 pages for database 'ms... The step failed.

Regards

Thillai

[markus_doehr2 · Accepted solution]

> I cannot take DB backup from SQL server and also from SAP too. Its getting failure.

> I changed the Tape drive and Tape also

Please check your Windows event log.

What Windows version is that?

Markus

[Former Member · Accepted solution]

Hi Markus,

Windows 2003. That too I checked. ...

Any other suggestion to find the problem...

Thanks

[markus_doehr2 · Accepted solution]

We see that you backup fails, the reason why can't be seen out of the logs you posted.

Markus

[Former Member · Accepted solution]

Thanks Markus.

Me too cannot find the problem from error logs...

1. I copied a dummy file to tape drive. Tape drive is working properly.

2. I tried with development server. Back up is running success with Tape Drive.

Tape back is not working on Production Server only . I am going to change the tape Drive card of production server to cross check..

Any other suggestion to check ...?

[Former Member · Accepted solution]

Hi,

Are you able to see the tape device in SQL Management Studio? if so try to create a dummy database and try to backup.

Uninstall and update the tape drivers on the production server and then check whether you are able to backup.

Regards,

SBK

[Former Member · Accepted solution]

Hi,

I taken a backup of Transaction log to tape drive. its working successfully.

But Database full back is getting failure.

Thanks

Thillai

Edited by: Thillai Govindarajan on Dec 18, 2010 12:00 PM

[Former Member · Accepted solution]

Hi Thillai,

I understand that you are unable to take backup from DB13, try taking backup from SQL Management Studio and let me know whether you face the same issue.

Are you using different tape device for dev and production?

Regards,

SBK

[Former Member · Accepted solution]

Hi SBK,

Cannot take backup from SQL Management Studio also. Showing error: Tape Expired. But the Tape is New one. dummy file is moving. trans log is moving. but db backup alone not working...

Thanks

Thillai

[Former Member · Accepted solution]

Hi Thillai,

Hope the below link helps you.

How to: Set the Expiration Date on a Backup (SQL Server Management Studio)

http://msdn.microsoft.com/en-us/library/ms188697.aspx

How to: Back Up a Database (SQL Server Management Studio)

http://msdn.microsoft.com/en-us/library/ms187510.aspx

Regards,

SBK

[Syamkriz · Accepted solution]

Can you check if there is an option to initialize the tape?

[Former Member · Accepted solution]

Hi syam,

Yes.

Thanks

Thillai

[Syamkriz · Accepted solution]

Can you check if there is a option to initialize the tape under db13

[Former Member · Accepted solution]

Hi

Yes I can able to initialize the tape.

Tape initialize (Check Box) is always selected.

Regards

Thillai

Edited by: Thillai Govindarajan on Dec 22, 2010 10:15 AM

[Former Member]

If i give the tape expiration day as 0 then tape backup is running else it is failure.

[Former Member]

Hi,

Call transaction DBACockpit / db02 -> Diagnostics -> SQL Error Logs -> ERRORLOG. - Check SQL Server Error log file.

Check Operating system application, system event logs.

Regards,

Nikunj Thaker

[Former Member]

Hi Nikunj Thaker

I dont know how to move after diagnostics. I cannot find the label - error log.

Thanks

[Former Member]

after moving to diagnostics are you getting SQL Error Logs ?

If yes double click on it.

Regards,

Nikunj Thaker

[Former Member]

Hi Nikunj,

After entering to dbacockpit->diagonistics-> <no Action> After double click....

Showing Error: Object CL_DB6_SYS: Method call GET_FIRST_AVAILABLE_SYSTEM failed with return code = System not found

Regards

Thillai