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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-18 : 08:33:57
|
| Shane writes "I have a 80 gig database and dropped a large table thereby reducing by storage by 40 gigs etc. The space allocated in SQL Server reflects the true size of the database and the space unsused represents 40 gigs . However Windows 2000 shows the database or NDF still as 80 Gigs etc.How can I get Windows to reflect the correct size of the NDF file at 40 gigs. RegardsShane" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-18 : 08:46:45
|
| You'd have to shrink the file using DBCC SHRINKFILE, it is documented in Books Online. Files don't automatically shrink to fit (unless you set the auto-shrink property on the database...may not work 100% right either) so Windows *is* showing the correct file size. |
 |
|
|
|
|
|
DBA Space allocated