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
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?