Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 NTFS file system limitation

Author  Topic 

richard102
Starting Member

25 Posts

Posted - 2013-10-23 : 09:26:52
On a dev/test Windows 2008r2 Server running SQL 2008r2 I compressed the datafile folder to free up some space. As the largest SQL database came up with recovery pending I backed-out and uncompressed the folder, but the mdf and ndf files within won't uncompress ("The requested operation could not be completed due to a file system limitation").

As I say its dev/test so I've already disabled sql-services and rebooted a few times.

The MDF is 1.3TB and the NDF is 200GB. The other NDF (17GB) uncompressed fine. Oh and the c-drive (the only drive) has 83GB free.

advice please

Richard

thanks

richard102

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-10-24 : 00:56:41
Uncompress, restore from backup.

http://support.microsoft.com/kb/231347
Go to Top of Page

richard102
Starting Member

25 Posts

Posted - 2013-10-25 : 08:17:01
lol, correct but unhelpful, lol

thanks

richard102
Go to Top of Page
   

- Advertisement -