Tuesday, March 20, 2012
Compressed Drive
I have been given the task of fixing a design problem. We have a 2 GB database (and growing) on a compressed drive. If I decompress the drive what impact if any will there be on the Database or data?This should increase your performance. As far as database concerns, you should not see any issues. However, backup or copy the database to another drive before you proceed. Also, run dbcc checkdb to check the database for any issues - run this before and after the operation. And make sure that you have enough disk space for the decompressed version of the database.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment