Log Shipping Configuration – SQL Server 2005



Step 1, Database Properties,
Configure Recovery Model


Step 2, Database Properties,
Transaction Log Shipping Page
{before LS configuration}


Step 3, Enable this as Primary


Step 4, Backup Settings Button


Step 5, Backup Settings Button,
Schedule Button


Step 6, Database Properties,
Add Button,
Initialize Secondary Database TAB


Step 7, Database Properties,
Add Button,
Initialize Secondary Database TAB,
Restore Options Button


Step 8, Database Properties,
Copy Files TAB


Step 9, Database Properties,
Copy Files TAB,
Schedule Button


Step 10, Database Properties,
Add Button,
Restore Transaction Log TAB


Step 11, Database Properties,
Add Button,
Restore Transaction Log TAB,
Schedule Button


Step 12, Transaction Log Shipping Page,
Secondary configured


Step 13, Database Properties, Use a Monitor Server Instance Checkbox, Settings Button


Step 14, Save Log Shipping Configuration