Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

In the olden days when I used to use other database platforms, we were advised to back up and restore our databases periodically to improve performance.

Common reasons were that a B & R would include

  • rebuild indexes
  • defragment pages

My questions:

What does MS SQLServer do (specifically 2005) when a back and restore is performed?
Should I be doing periodic backups and restores?
Should I be worried about losing statistics?

share|improve this question
add comment

2 Answers

You should be doing periodic backups and restores to test your restore procedures, but as far as doing them to improve performance, you can rebuild indexes and shrink files with Maintenance Plans, which is the preferred method.

share|improve this answer
add comment

Backups/Restores are carried out at byte level - they have no affect on fragmentation in the database.
Restores should be done regularly to make sure you are confidant in how the process goes (including getting the system attached to the restored database) and that the backups are proved to be usable. Your other answer is correct in saying that index maintenance is a separate process you need to carry out.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.