Looking for a simplified explanation and strategy for a nightly maintenance plan for SQL Server 2008
Posted on 2010-01-05
I am running a program called ShipWorks that is connecting to a SQL Server 2008 instance(running on XP with decent hardware). I am looking for suggestions and some newbie knowledge transfer on a nightly maintenance plan to keep the db(or all the databases) healthy and performing.
What I am currently doing:
Backing up all databases nightly with a maintenance plan I assembled via the wizard.
What I would like to do(and know more about):
Index and compact the db, plus whatever else is a best practice and just a good idea to keep things maintained. I'd like to assemble this via the wizard as well, which I don't think I need much help with. I would like to know that the actions I perform aren't going to hose the db.
Disclaimer: I have almost NO db admin experience, but work with a guy who is handy with MySQL.
Thanks in advance,