Encountered the following error while trying to restore as compressed for large databases
LiteSpeed(R) for SQL Server Version 7.0.4.2 (64bit)
Copyright 2012 Quest Software, Inc.
Msg 61700, Level 16, State 1, Line 0
Unexpected termination on thread: 2, Return code: x2DB4
RESTORE DATABASE is terminating abnormally.
Write on "???" failed: 33(failed to retrieve text for this error. Reason: 1815)
Please check the following
1. Is the destination folder in fact a NTFS compressed folder?
2. Can the backup be restored normally (read/write non-compressed)?
3. Is there enough disk space in the destination folder?
4. What is the "Size on disk" (right-click Properties in Windows Explorer) for the mdf and ldf file?
5. What is the size of the original uncompressed mdf and ldf files?
6. How big is the backup file?
7. If using Windows 2008, was the hotfix http://support.microsoft.com/kb/967351/en-us applied?
8. Able to restore as compressed natively? Please note in order to do that, the database needs to be read-only when backup was taken.
9. Any error when using Windows to compress the files?
a) Restore the database normally (not compressed)
b) Flag the database as read only from Management Studio
c) Detach the database from Management Studio
d) Compress the MDF and LDF files from Windows Explorer by flipping the compression flag (right-click Properties)
e) Attach the database
