SQL Server 2000 SP4 was used to set up log shipping in this example.

Before setting up log shipping, you need to first register the primary, secondary and monitor servers in Enterprise Manager.  The secondary server may also be used as the monitor server, but you should use a different server if possible so that you are alerted when the secondary server fails.

Step 1 - registering the necessary servers

Step 2 - starting the maintenance plan wizard

Step 3 - the maintenance plan wizard welcome screen

Step 4 - selecting the database to log ship

Step 5 - selecting backup options

Step 6 - entering the network share name

Step 7 - adding destination servers

Step 8 - log shipping destination details

Step 9 - confirming the log shipping destination

Step 10 - initializing the destination databases

Step 11 - log shipping schedules

Step 12 - log shipping alert thresholds

Step 13 - setting up the monitor server

Step 14 - Maintenance Plan summary

Step 15 - Enterprise Manager task list

Step 16 - SUCCESS!