NTFS file system limitation - SQL Server Forums

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

richard102
Starting Member

25 Posts

Posted - 2013-10-25 : 08:17:01

lol, correct but unhelpful, lol

thanks

richard102

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources