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 - 2005-12-06 : 13:14:56
|
| Lance writes "can SQL 2000 or 2005 defrag a database??? if yes how??? if not is there anything out there that Can??thanks,Lance" |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-06 : 16:21:57
|
| SQL 2000 can either using REINDEX or DEFRAG (DBCC commands)But this won't remove physical fragmentation of the database files, which its also worth doing IMHOKristen |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-06 : 16:27:12
|
| you can use a tool called 'contig' from the guys at sysinternals to handle the external file fragmentation. Fixing external file fragmentation is not an online operation, it will take some downtime especially if the datafiles are large.This something you would do if your datafiles have thousands of fragments.Here is the link to contig http://www.sysinternals.com/Utilities/Contig.html-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-06 : 16:28:54
|
| Good utility that one, its the one we use for single-file-defrag'ingKristen |
|
|
|
|
|
|
defrag Database