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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 script for shrinking

Author  Topic 

DBA007
Posting Yak Master

145 Posts

Posted - 2010-08-09 : 06:46:21
can any one provide sql script for shrink db by small increment

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-09 : 07:07:26
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 Shaw
SQL Server MVP
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-08-09 : 13:39:29
DBA007 - have you recently deleted data and want to permanenetly reclaim the space? Otherwise follow advice above

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -