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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy