0xe000943f - Database s failed to freeze for backup. This can be caused if the database is in a state that does not support backup; such as offline, standby, or recovering

Article: 100047872
Last Published: 2022-08-29
Ratings: 5 8
Product(s): Backup Exec

Problem

When attempting to back up Microsoft SQL databases job fails with error "0xe000943f - Database s failed to freeze for backup.  This can be caused if the database is in a state that does not support backup; such as offline, standby, or recovering"

Error Message

0xe000943f - Database s failed to freeze for backup.  This can be caused if the database is in a state that does not support backup; such as offline, standby, or recovering

 

Debug Logs :

BEREMOTE:  [7640]                          - Status 'Unspecified error (0x80004005)' for 'GetBeVssWriterVolumes( CBeVssHelper::SQL_WRITER, ppGetBeVssVolumeList, sqlDB, sqlInstance, GUID_NULL, refresh, dwMillisecTimeout )' in 'CBeVssHelper::GetSqlDependantVolumes:1647

 

BEREMOTE:  [7640]    [fsys\sql2]          - failing backup because database did not prepare correctly
BEREMOTE:  [7640]    [fsys\sql2]          - Returning Database model - Log backup supported
BEREMOTE:  [7640]    [fsys\sql2]          - Database Object built model
BEREMOTE:  [7640]    [fsys\sql2]          - GetDatabaseState model
BEREMOTE:  [7640]    [fsys\sql2]          - GetDatabaseState SQL 2K5+ 0
BEREMOTE:  [7640]    [fsys\sql2]          - status logged
BEREMOTE:  [7640]    [fsys\sql2]          - status online
BEREMOTE:  [7640]    [fsys\sql2]          - GetDatabaseState msdb
BEREMOTE:  [7640]    [fsys\sql2]          - GetDatabaseState SQL 2K5+ 0
BEREMOTE:  [7640]    [fsys\sql2]          - failing backup because database did not prepare correctly

 

 

Possible cause : 

1. If the SQL server VSS writer is missing from the list of VSS writers

2. If SQL browser and SQL server VSS writer are disabled or not present may cause the above error . 

 

Missing Services : 

 

Missing SQL server VSS writer: 

Solution

SQL browser and SQL server VSS writer has to be running and SQL server Writer has to be stable with No error .

If the SQL server writer is missing from VSS writers , can perform a server Reboot . If the services ,SQL browser and SQL server VSS writer were not present ,Contact Windows Administrator or Microsoft . 

Note :To Check VSS writer status open Command prompt as Admin and type Vssadmin list writers 

Was this content helpful?