on 12-15-2010 9:42 AM
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ...?
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
If i give the tape expiration day as 0 then tape backup is running else it is failure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.