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 |
|
jagpalsingh4
Starting Member
7 Posts |
 Posted - 2008-09-03 : 08:50:54
|
| Hi, I used this script for shrinking database ,but i read somewhere that dont use shrink command if its bigger than 5gb and i dont know what the use of 1 and 10 in this script .dump tran HFM with no_log;DBCC SHRINKdatabase(HFM,1)DBCC SHRINKFILE(HFM_Log, 10)so plz help and give me ur suggestion RegardsJagpal Singhjagpalsingh |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-03 : 09:30:17
|
| This has been discussed no of times.Read this carefully why you shouldn't shrink database.http://www.karaszi.com/SQLServer/info_dont_shrink.asp |
 |
|
|
|
|
|
Shrinking database