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 |
|
na2173
Starting Member
38 Posts |
 Posted - 2003-09-24 : 15:23:29
|
| I have a database base which is 78Gb and it has a free space of 32gb , i ran the DBCC shrinkdatabase with a 10 percent freespace and with option truncate only, it shrank the database only by 1gb, now i running DBCC Shrinkfile, this takes long time to run, does any body has a good suggestion for me to shrink the database quickly |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-24 : 15:34:49
|
| There is no other way to shrink. Yes shrinking the database is going to be slow. That is why it should be performed during a maintenance window or when there is very little activity on the server, which would mostlikely be at night.Tara |
 |
|
|
na2173
Starting Member
38 Posts |
Posted - 2003-09-24 : 15:45:11
|
| It is being running since 5 hours, does it takes that long, nothing is going on that server, and it a new server and the only command i am running is dbcc shrinkfile |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-24 : 16:10:39
|
| 78GB is quite large. Yes it will take a long time. To verify that it is still running, check the CPU column in sysprocesses for the spid that is running the command. As long as CPU is increasing, it is still running.Tara |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-09-25 : 02:41:04
|
quote:
Originally posted by na2173
I have a database base which is 78Gb and it has a free space of 32gb , i ran the DBCC shrinkdatabase with a 10 percent freespace and with option truncate only, it shrank the database only by 1gb, now i running DBCC Shrinkfile, this takes long time to run, does any body has a good suggestion for me to shrink the database quickly
Not that this answers your question, but I'm just curious about how many datafiles you have.-ec |
|
|
|
na2173
Starting Member
38 Posts |
Posted - 2003-09-26 : 13:34:49
|
| i have only one datafile |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-09-26 : 14:00:37
|
| Holy cow, a single 46GB MDF??? How does that perform? What sort of IO system is it stored on??Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
|
|
DBCC Shrinkfile runs very slow in sql2000