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 |
|
haneesh
Starting Member
7 Posts |
 Posted - 2009-04-18 : 04:46:32
|
| Hi,I want to shrink a database with size of 10Gb.I got some useful tutorials to do that.But i want 2 know the what are the precautions need to take before shrinking a db.(Prevent data loss).And also mention all the steps ,including the process of db shrink.After shrinking how can i check the Db size actually shrinked or not??Plz help me..I'm new to these area of SQL |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-18 : 06:04:47
|
| Why do you want to shrink? 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 DB