question

SQLnovince avatar image
SQLnovince asked

One database failed to complete backup in a group of alwayson.

The environment is AlwaysOn Sql for sql 2014. The backup tool is netbackup.

All the databases are being backed up in the group. However, for one database the message first is "BACKUP DATABASE successfully processed...". Then this is followed by "BACKUP failed to complete the command BACKUP DATABASE xyz".

The application log has

SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1872. Thread=14340. Server. Instance=MYSQLName. VD=Global\VNBU0-xxxxx-xxxx-xxxxxxxxxx_SQLVDIMemoryName_0

The list vss admin writers shows no errors. All of the other databases in the group are being backed up with no errors.

Also, I see that for other databases there are multiple "database backed up" messages. This one has one "database backed up" message which then follows with failed to complete the command.

dbcc checkdb returned 0 errors on the database in context.

backupalways-onsql 2014
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.