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 |
nori_venkat
Starting Member
2 Posts |
Posted - 2010-06-03 : 16:40:46
|
HiI've a sql server 2000 database of 20gb size. I have rebuilt indexes using DBCC command for all the tables in database. Now, system shows 12 GB of occupied space and 8 gb of free space. When I take backup I get backup file of 12 or 13Gb. how to recover the free space. Because the physical database file (not transaction log) is occupied 20gb on hard disk.please help me |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|