17027: Acronis Backup Software: VSS Backup Fails with "Failed to create volume snapshot" on a Machine with Microsoft SQL Server 2000

Change the databases to Simple Recovery Mode

Symptoms

  1. You install Acronis backup software on a machine with Microsoft SQL Server 2000;
  2. You create a disk/partition backup with Create snapshots using VSS option activated;
  3. Backup operation fails with the error message:

    Failed to create volume snapshot

  4. In the Windows Event Log (Control Panel -> Administrative Tools -> Event Viewer), there is an error entry similar to the following one:

    Event Type: Error Event Source: VSS
    Event Category: None
    Event ID: 6004
    Date: DATE
    Time: TIME
    User: N/A
    Computer: COMPUTERNAME
    Description: Sqllib error: Database NAME is not simple.

Cause

This is a Microsoft issue. Acronis backup software is unable to create a snapshot using Windows VSS service if the recovery model of the SQL Server database is configured to use an option that is different from Simple.

Solution

Set Microsoft SQL Server 2000 database to Simple Recovery Mode as described in Microsoft Knowledge Base Article 828481.

More information

See also:

 

Tags: 

You are reporting a typo in the following text:
Simply click the "Send typo report" button to complete the report. You can also include a comment.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
5 + 12 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.