I have sql server 2000 database installed on compressed drive. i was recently made awaere that this is not supported so i want to decompress this drive.
I know have to uncheck the option 'compress this drive to save disk space' What other steps are required? What are the implications for the existing database? Will it affect it? Do i need to have sql services turned off while the decompression is in progress?