Sunday, July 7, 2013

How to backup SQL Database automatically Maintenance Plans

There are some simple ways to do.Follow the steps first

Go To SQL Server Configuration Manager > SQL Server 

Services > Run SQL Server AgentAnd set it to run automatically


Then go to SQL Server Management Studio, Find TAB Management > Maintenance Plans. Right Click > Maintenance Plans Wizard.


Text your maintenance plans, ex: DailyBackup. Select Option button : Single Schedule for entire task.

Click Configure > Set Schedule according your demands.

Then you have to Select Maintenance tasks. for this case, you choose Full Database backup.
Click Next, then define which database to backup, set backup location, and backup extension.

Again Click Next, Choose your report mode, then Finish.

Thats all and be happy!!!

Gud Luck for all

No comments:

Post a Comment