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 |
|
DLTaylor
Posting Yak Master
136 Posts |
 Posted - 2008-08-19 : 05:28:38
|
| I am using SQL 2000 and have dropped a number of large tables from my database.Is there any good practice i should adopt following the deletions?(e.g. The *.mdf and *.log files do not appear to have changed size - should i do anything with them?)Any advice will be much appreciated. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-19 : 06:04:07
|
Leave as is, unless there is an urgent need to reclaim physical disk space.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
DLTaylor
Posting Yak Master
136 Posts |
Posted - 2008-08-19 : 06:27:47
|
| Thanks Peso, Cant argue with that - much of the literature i have read seems to agree with your point.given i have plenty of disk space... i will leave alone.Thanks! (again) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-19 : 09:23:29
|
The backside with shrinking the files, are that later (when you need more space again) the files might get [more] fragmented.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Best practice after big deletions