Restore: MSSQL on compressed folders

Last post 12-12-2013, 5:29 AM by jankete. 2 replies.
Sort Posts: Previous Next
  • Restore: MSSQL on compressed folders
    Posted: 12-11-2013, 5:55 AM

    Hi,

    we've got a MSSQL database on Win2003 which resides in compressed folder. The backups were all successfull, but when we want to restore a database (under new name) to that folder, we got the following error:

    Query Result [The file "D:\Microsoft SQL Server\TEST\IFLEX_2.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
    The file "D:\Microsoft SQL Server\TEST\IFLEX_1_2.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
    Problems were identified while planning for the RESTORE statement. Previous messages provide details.
    RESTORE DATABASE is terminating abnormally.
    An exception occurred while executing a Transact-SQL statement or batch.].
    When we repeat the restore to an uncompressed location on the same client, it works well.
    Is there anything official handling MSSQL on compressed folders with Simpana (our version is 9SP11b).
    Thanks,
    Janko 
  • Re: Restore: MSSQL on compressed folders
    Posted: 12-11-2013, 4:55 PM

    Starting with SQL 2005, MS SQL does not support having read-write database files on compressed volumes.  See this MS TechNet blog: SQL Server 2005 and compressed drives - what you should know?.  MS also has a KB article which details why running read-write DB files on compressed volumes isn't a good idea: KB231347.

  • Re: Restore: MSSQL on compressed folders
    Posted: 12-12-2013, 5:29 AM

    That was what I were looking for. Now I can tell our SQL admins, that is not a simpana fault and that they should not run their database on compressed folders.

    Thanks!

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy