I'm currently taking the MS SQL 2K5 Admin course at a local college and ran into a problem with the Log Shipping part.
My setup is the following:
Windows 7 x64 SQL 2005 SP3 2 SQL server instances on the same machine
Log Shipping settings:
- Performed full then log back up of Primary
- Manually restore on Secondary in STANDBY MODE
- Insert a new record into the table
- Set up Log Shipping on Primary using SQL Authenication login to connect to the Secondary
- Set up timers and copy destination on Secondary
- Monitoring instance not being used
I set up a shared folder for WORKGROUP so both instances on the machine can read & write to it. I can see transaction logs generated and copied as defined by the Transaction Shipping wizard. However, the specified table on the Secondary instance is not updating.