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!!!
➢ 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
Post a Comment