alarmgerma.blogg.se - Sql management studio 2008 r2 scheduled backup

The bottom left pane shows the tasks that can be utilized to create an sql maintenance plan. Choose a time so that the database is least used. The marked area in the right top will be used to configure the time that the plan executes. Note the marked area, these are the two areas you need to use for setting up the maintenance plan. Now you will be in the configuration page for the maintenance plan. This will identify your backup plan and you should choose a relevant name that suits your plan. Right click the maintenance plan and then select “new maintenance plan”.Įnter the maintenance plan name in the popup box (This can be any name that identifies your task for ). If you dont see the maintenance node, make sure you have the necessary permission. To schedule maintenance plan, you need to have “SYSADMIN” database role.

Now from the object explorer, make sure SQL server agent is running, if not start SQL server agent(Right click and press start).Įxpand the Management Node from the object explorer, and then select the maintenance plan node. Login to Sql Management studio and connect to the required database.

Delete the backup copies after a certain period of timeįirst I am going to tell you the steps required to schedule the backup.

Users to schedule the backup to be taken on a particular interval.

In this blog, I am going through step by step that will allow Microsoft SQL server 2008 made this task very easy. It is very important to take backups for the database files on regular basis.