October 27, 2011 at 3:50 pm
i have dropped all the non clustered indexes on the database and can see a lot of free space in the data files. dbcc shrink file is really taking long time to shrink.any tricks to have the magic ?
there are two datafiles mdf - 1 tb -- 600gb occupied rest all free
ndf - 580 gb -- 10gb occupied rest all free
???
October 27, 2011 at 4:23 pm
What are you trying to achieve here?
Are those nonclustered indexes going to be recreated?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 6:05 pm
I will be using this database for reports .... to setup replication
October 28, 2011 at 2:20 am
Ok, so why are you dropping the nonclustered indexes and trying to shrink it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply