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