Database Shrinking

Question

Database Shrinking

y.koteswarrao-652921

SSCrazy

Points: 2010
More actions
August 19, 2010 at 11:14 am

#146689

Hi,
As per my Database Shrink is used to release unused space to OS,when is gone through the some blogs,it is written that database shrink can be used when unusual growth of data and log files.
How database shrink works when unusual growth of data and log file....could any body explain in detail?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

More correct to say shrink should only be used if there has been unexpected growth of data or log (or a massive archiving operation) to get things back to normal after the cause of the unexpected growth has been addressed.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

To begin to obtain an understanding of log files may I suggest you read this excellent article by Gail Shaw

http://www.sqlservercentral.com/articles/64582/

Then progress to these:

http://www.sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-More-on-the-circular-nature-of-the-log.aspx

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx%5B/url%5D

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]