Applies To:
Microsoft SQL Server 2008 R2
Tasks:
Backup Database and Restore using Maintenance Plans.
Example:
* Backup Database “DB_Test”
from Server “IT107\SQLSVR_1” to Local Drive
-> Maintenance Plan Name : Backup
* Restore file backup, to Database “DB_Test_Simulasi”
in Server “IT107\SQLSVR_2”
-> Maintenance Plan Name : Restore
For download a file .pdf, please open this link:
https://docs.google.com/open?id=0B6a5vK3IVP_0blFobTJQaHE2aVk