Log in the DB server with any one of the service account (Account has local admin rights)
Start the SQL management studio(SSMS)
This was done on SQL 2008 R2, but it’s very similar on SQL 2008 and SQL 2005, so if you’re using either of those you should be able to follow along. Under Management right click on “Maintenance Plans” and click “Maintenance Plan Wizard.”
Give the plan a name, like “Backup Database.” You can also schedule the backups to run on this screen by clicking “Change…”
Next we’ll pick the things our maintenance plan will do we’ll check “Back Up Database (Full)” as well as “Check Database Integrity.” Corrupt databases back up just as well as uncorrupted databases. It’s good to run an integrity check just to make sure you’re backing up something that will actually help you if you need to do a restore.
Next choose the order the two jobs will run in. We’ll leave this at the defaults
Next we pick which databases the integrity check will run against. Choose “All databases.”
Next we get to configure the backups. We are also going to back up “All databases” to make sure we get everything. I also leave the defaults that create one file per database but do not create a folder for each backup
The Maintenance Plan is created. Of course it needs to run before it does us any good. To run Maintenance Plan right click on it and click Execute.
If this is the first time you’ve tried to run a Maintenance Plan on your SQL instance you might get the following error:
Just like the error says, this is because the SQL Server Agent is not started. To fix that, right click on the SQL Server Agent and click Start
Now try to execute your Maintenance Plan again. It should work.
No comments:
Post a Comment