How to setup log shipping in sql server 2005 step by step

SQL Server 2005 SP2 was used to set up log shipping in this example.

Step 1 - the servers that will be used in this example

Step 2 - starting the log shipping setup

Step 3 - starting the backup configuration

Step 4 - entering the backup settings

Step 5 - secondary server settings - database initialization

Step 6 - secondary server settings - file copy settings

Step 7 - secondary server settings - restore settings

Step 8 - setting up the monitor server

Step 9 - initilization tasks ran and jobs set up

Step 10 - SUCCESS!

---

Posted in: SQLServer