It might also be wise to only rebuild the indexes that are fragmented enough to need rebuilding. There is script in BOL that you can use that will re-build indexes...

Good question Steve.

Nice link Dave. I like the fact that the google search points you a forum post on SSC asking the same question.

bcb (1/27/2011)

---

Well everybody, I'm pleased my comment about starting a db maintenance job with DBCC Checkdb inspired such discussion. Just to add some clarification... I have all of my sql...

Hi Abi, I'm pleased you enjoyed the article.

Taggs (1/27/2011)

---

Sorry Gethin you are totally right.

I was only trying to be helpful by giving another DBA (and others that read these forums) something for consideration. I think it...

The point I am making to think about is, if you have a corrupt database that will restore at least you have a fighting chance. If you have a corrupt...

The way to recover a from...

Taggs (1/27/2011)

---

Grasshopper :

Surely if your Database is corrupt it is all the more reason to back it up? At least if you have a backup you have something to restore...

Thanks Rahul I'm glad you like it.

Another good...

Nadrek, Thanks for your comment, this article was meant to be about maintenance/housekeeping of backup files. The points you raise are good points and although its not a 'how to...'...

jasona.work (1/26/2011)

---

Thank you! I'd not looked at the History Cleanup task, so I didn't know what it might do (yes, I'm rather new to managing an SQL Server, and...

Martin Hawley (1/26/2011)

---

Good article and led me to check our backup plans set up by a contractor. Discovered that there is no clearing of the backup and restore history and...

Taggs (1/26/2011)

---

I usually perform the clean up before the backups, that way, it will make the most efficient use of disk space and backups are less likely to fail due...