Click here to Skip to main content
12,696,832 members (30,261 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


1 bookmarked

Database Snapshot Failed Due to Disk Space Issue

, 29 Jan 2014 CPOL
Rate this:
Please Sign up or sign in to vote.
Database snapshot failed due to disk space issue


Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML operations on database. But if disk containing snapshot file runs out of space, then what will be the impact on new transactions, database & snapshot?

Microsoft design snapshot in very well manner. If Snapshot failed to records the data changed by DML transaction due to disk space issue, then your snapshot will become unusable & reaches to suspect mode and on the other hand your actual database will keep running un-impacted.

Snapshot database cannot be recovered from suspect state so you need to drop & recreate the snapshot database.

  1. While running the below transaction, we got an error that we are unable to write on snapshot file due to disk space issue.

  2. We check data in table to check id transaction completed successfully or failed due to snapshot issue. We found transaction is completed & database is running fine.

  3. After that, when we try to select snapshot database, we get an error that database is suspect mode.

  4. We also try to bring snapshot database in emergency mode to see if we can troubleshoot it but we get an error that this operation cannot be performed on snapshot database.

If you liked this post, do like on Facebook at

Reference: Rohit Garg (


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

No Biography provided

You may also be interested in...


Comments and Discussions

-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170118.1 | Last Updated 29 Jan 2014
Article Copyright 2014 by Rohitmssqlfun
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid