SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 NTFS file system limitation
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

richard102
Starting Member

United Kingdom
24 Posts

Posted - 10/23/2013 :  09:26:52  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 10/24/2013 :  00:56:41  Show Profile  Visit russell's Homepage  Reply with Quote
Uncompress, restore from backup.

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

richard102
Starting Member

United Kingdom
24 Posts

Posted - 10/25/2013 :  08:17:01  Show Profile  Reply with Quote
lol, correct but unhelpful, lol

thanks

richard102
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000