Menu
header photo

SQL-Talk

Talks all about SQL Server and Azure

Blog Search

Blog Archive

Comments

There are currently no blog comments.

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

October 2, 2017

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