Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2012-02-17 : 22:06:48
|
| whenever I shrink any database on 2000 / 2005 server it shrinks initially but later in the next transaction it increases twice.In reality the MDF and LDF were more than the actual backup file size and in that anticipation needs to get shrinked; but after shrinking for the next transaction time the MDF and Corresponding LDF were increasing drastically.Is there any solution as to how it can be shrinked still won't increase as a result of next transaction / backup.Any valuable solution. Thanks. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-18 : 05:00:55
|
| Yeah, stop shrinking your database and set a sensible growth increment.Databases tend to grow as more data gets put in them. It's in their nature.Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets added. When that happens, the entire system will slow down as the file is expanded. Also repeated shrinks and grows will cause fragmentation at the file-system level, which is hard to fix.See - [url]http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Shrink increases on Server