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 |
|
askcomputer
Starting Member
12 Posts |
 Posted - 2006-09-18 : 23:18:38
|
| HiI have 75 gb database I delete some tables then after i try to shrink using sql script dbcc shrinkdatabase (xxx,10) and dbcc shrinkfile (xxx,7) but database can't reduced size. script still runing. i check database properties there show 49 gb fress space avialable. How remove allocated space.RegardsSantosh |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-19 : 05:33:40
|
| What if you wait with using second DBCC commands until first DBCC command is executed properly?Peter LarssonHelsingborg, Sweden |
 |
|
|
EugeneZ
Starting Member
26 Posts |
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-09-19 : 18:40:12
|
| With a 75Gb database and with 10% shink will take a long time, so be patience or do what Eugene said. |
|
|
|
|
|
|
Shrink Database