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 |
|
cbeganesh
Posting Yak Master
105 Posts |
 Posted - 2005-05-02 : 11:55:05
|
| HelloIm running dbcc shrinkfile(1) and 2 from sql query analyser. But it takes for ever, but when i do the shrink db from the enterprise menu , It takes few minutes. is there any other way to shrink db from T-SQLThanks |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2005-05-09 : 08:56:36
|
| -- SHRINK temp Database to 10 megDBCC SHRINKDATABASE (TempDB,10) |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-05-09 : 10:16:39
|
| Bear in mind that when you run the shrink db from the enterprise manager it is most likely running a different type of shrink from the one that you are saying takes a long time. The amounts of space regained would not be the same. If you actually go into the detail on EM and choose to shrink the files to a certain size it would probably take as long.-------Moo. :) |
|
|
|
|
|
|
DBCC takes long time