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.
