Menu
header photo

Blog Search

Blog Archive

Comments

There are currently no blog comments.

What may be the possible scenarios of backup failures in SQL Server?

Possible Backup failure scenarios

  • Disk was full
  • Server was busy.
  • Problem with the n/w
  • Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\node-1\Backups\master.bak'. Operating system error 1326(The user name or password is incorrect.).Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.
  • If domain is not running and SQL Server Service is running with domain account.

         Message: The job failed.  Unable to determine if the owner (OPTIMIZE\rehan) of           job Inventory backup has server access (reason: Could not obtain information                  about Windows NT group/user 'OPTIMIZE\rehan', error code 0x54b. [SQLSTATE          42000] (Error 15404)).

  • Problem with MSDB and SQL Agent
  • If there is disk I/O error while reading from data or T.Log files.
  • CHECKSUM errors
  • Database has entered into suspect or restoring.
  • T.Log file was full. (Only log backups are allowed other backups fail)

Go Back

Comment