I’ve been working on setting up a maintenance plan in SQL Server on one of our production servers. Right now we back the whole server up nightly, but we have a machine that I’d like to get some more granularity to our backups. While trying to figure this whole thing out I stumbled on this book: Brad’s Sure Guide to SQL Server Maintenance Plans. It was published back in 2009, referencing SQL Server 2000, 2005 and 2008. I’ve gotta say, so far every screen I’ve pulled up using this book matches the screenshots, or with very minor changes. Which is really weird for Microsoft as they seem to like to change things on regular basis.
There’s a lot of information in this book, but I’ve found it to be a big help. There’s a link to a free PDF version, I highly recommend checking it out if you’re not a DBA. 🙂