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 |
Document history
| 6/27/2008 | Initial release. |