Home Forums SQL Server 2005 Backups Maintenance plan backup activity screwed by adding a snapshot RE: Maintenance plan backup activity screwed by adding a snapshot

  • This actually does not have anything to do with the database snapshot that you created. If you look at the message, the error is on the MSDB database:

    Executing the query "DBCC CHECKDB WITH NO_INFOMSGS

    " failed with the following error: "A database snapshot cannot be created because it failed to start.

    Write to sparse file 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\MSDBData.mdf:MSSQL_DBCC7' failed due to lack of disk space.

    And, the failure is due to a lack of space on the volume containing that database. Integrity checks are not performed on the actual database, but are normally performed on an internal snapshot of the database.

    When the system cannot generate the sparse file - or the sparse file being used for the snapshot runs out of space, you get the above error message.

    Simple put, you have run out of space on the C:\ drive. Identify what is taking up all of the space and purge it, or expand the volume.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs