Backup of
SQL Database fails with the following errors:
[Critical]
From: OB2BAR_Main@sqlsrv01.in.com "SIDDBS01" Time:
3/9/2014 6:31:55 PM
Error
has occurred while executing a SQL statement.
Error
message: 'SQLSTATE:[08004] CODE:(911) MESSAGE:[Microsoft][ODBC SQL Server
Driver][SQL Server]Database 'DBN01' does not exist. Make sure that the name is
entered correctly.
SQLSTATE:[42000]
CODE:(3013) MESSAGE:[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
DATABASE is terminating abnormally.'
[Critical]
From: OB2BAR_Main@sqlsrv01.in.com "SIDDBS01" Time: 3/9/2014
6:31:55 PM
Virtual
Device Interface reported error:
The
object was not open.
See
also Data Protector debug.log and SQL Server error log for details.
[Normal]
From: OB2BAR_DBN01@sqlsrv01.in.com "SIDDBS01" Time: 3/9/2014
6:31:57 PM
Completed
OB2BAR Backup: sqlsrv01.in.com:/SIDDBS01/DBN01/0 "MSSQL"
[Major]
From: OB2BAR_DBN01@sqlsrv01.in.com "SIDDBS01" Time: 3/9/2014
6:31:57 PM
Aborting
connection to BSM. Abort code -2.
Solution:
>> Remove the DB 'DBN01' from backup spec, if it doesn't
exists in the SQL server.
[OR]
>> Check if the DB was dismounted, If so mount the
database 'DBN01' and bring it online.
Trigger the backup and see if it's successful.
Error has occurred while executing a SQL statement.
ReplyDeleteError message: 'SQLSTATE:[42000] CODE:(3201) MESSAGE:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'Data Protector_(DEFAULT)_msdb_040031544_0'. Operating system error 0x80070005(failed to retrieve text for this error. Reason: 15105).
SQLSTATE:[42000] CODE:(3013) MESSAGE:[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
no
ReplyDeleteis it works for anyone?
ReplyDeleteis this works for someone?
ReplyDeleteThis blog is full of information and provide very useful information on SQL DB backup. Thanks for sharing
ReplyDelete