Question

  Asked: Sep 19 2004   6:06 AM GMT
  Asked by: CyberJ


Defrag SQL Database


SQL Server 2000, SQL Server

To my understanding, a normal defrag application will not defrag a SQL database.

How would this be done, how would you defrag a SQL database?

What applications could you use and/or what commands would you use?

Kind Thanks.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



Diskeeper would be a way to degrag the physical database files and then use DBCC REINDEX to rebuild the indexes.

A search on Google for defrag SQL shows a couple of articles about this
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

bakash  |   Sep 20 2004  12:42AM GMT

Yes, for external fragmentation u can use Disk keeper…
n for internal fragmentation u can use DBCC REINDEX..
but Theres another option for internal fragmentation…
DBCC INDEXDEFRAG, its an online operation. It does not hold locks long term and thus will not block running queries or updates.