SHEDULING OF SQL SERVER BACKUP IN SQLSERVER 2008

      SCHEDULING OF DATABASE  BACK UP IN SQL SERVER 2008
                        
➢  Go to  Maintenance  plan  Under the  Management tab  



➢    Right click to maintenance tab  > Maintenance tab wizard➢   click onto change button  u need to provide necessary details as shown below,










➢ click OK and next





  You need to select the tasks for which this maintenance plan should work,here I select the back 
up for full data base
 

 click next

Complete the details


 


Next options allows you to save the report of maintenance plan action in to your desired location

 


next dialog box shows the choices that you made in the wizard,verify it and click finish.
 


Now double click maintenance plan  under Maintenance plans  to view the plan details
 

To make a final testing prior to scheduling make a right click to Maintenance plan and click execute

 




Now  check the Back up in
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup



AND YOUR BACK UP IS THERE!!!

Comments