November 20, 2008 at 7:50 am
How can I check how long I was shrinking a database. Is there a log to check or script to run?
November 20, 2008 at 10:38 am
yulichka (11/20/2008)
How can I check how long I was shrinking a database. Is there a log to check or script to run?
Why are you shrinking the database?
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
November 20, 2008 at 11:01 am
To clean up the white space
November 20, 2008 at 11:16 am
yulichka (11/20/2008)
To clean up the white space
What white space?????
November 20, 2008 at 2:00 pm
Databases need free space within them. They're not like word documents where white space is wasted. You should leave a fair amount of free space within the data file. If you don't the files will have to grow frequently which will cause a number of other problems.
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
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
November 20, 2008 at 2:53 pm
This article will give you some insight into why shrinking is often a bad idea: http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply