SHRINK

[baran121]

hi i need to shrink my db.

i wanna be sure about it.

what is the defference between
DBCC SHRINKDATABASE (mydb)
and
DBCC SHRINKDATABASE (mydb,15)

is there any problem if i use DBCC SHRINKDATABASE (mydb)

thank you..

 

[TheBugSlayer]

Baran121, 15 in your case means you want to shrink the file and leave 15% of the space free.



MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)

 

[baran121]

thank you TheBugSlayer,

but i know that 15 in my case means i want to shrink the file and leave 15% of the space free.
i mean if i use DBCC SHRINKDATABASE (mydb)
for all free space. is there any problem, maybe database will slow down.
and i wanna shrink my database every sundey night.

 

[markros]

Take a look at the blogs posted in the comments to this blog

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/truncate-log-in-all-your-user-databases

(first 3 comments with the links). Then you may want to re-consider.

PluralSight Learning Library