Database Reorganise

[pjw001]

On reporting an error in some software that uses SQL Server the supplier of the software has advised me that I should reorganise/reindex the database.

He has advised that the easiest way to do this is to backup and restore the database.

Does anyone have any comments on this?

Thanks.

 

[olahallengren]

Microsoft has some recommendations about index defragmentation.

http://msdn2.microsoft.com/en-us/library/ms189858.aspx

I think that you should consider doing a rebuild of all your indexes. You could also do it dynamically based on the fragmentation level. I have a stored procedure that could help you with this.

http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html

There could also be fragmentation in the file system. This could happen if you do a lot of growing and shrinking of the data and log files.

Chad Boyd has a blog series on this topic.

http://blogs.mssqltips.com/blogs/ch...9/custom-index-defrag-rebuild-procedures.aspx

Ola Hallengren

http://ola.hallengren.com

 

[pjw001]

Thank you very much for the reply. Those references you gave were extremely interesting.

However, as far as I could see, none of them answer the question "Does backing up and restoring a database reorganise the tables?

 

[jasper06]

No backup and restore will not reorganize the database. you need do rebuild indexes depend upon operations priorities

 

[pjw001]

Thanks. That is as I thought.