I set up log shipping using the maintenance plan wizard. Everything seems to have setup properly. The transaction log backups work properly. The copying of the logs from Server A to Server B works properly, but it doesn't seem to load the transactions into the database on the secondary server. To test this I created a small table in the database on Server A. I see the transaction log file be created, be moved to Server B, but I never see the table in the database on Server B.

I've created the plan setting the database load state to both no recovery mode and standby mode (with and without terminate users in database checked). In the no recovery mode, the database on Server B is always in a Loading state and I can never look into the database to see if the table was created (its a small table, 4 fields totally 80 characters).

Anybody know what is happening here and have any ideas how I can fix this?

Thanks,
Josh

Please don't cross post to any SQL newsgroup ... it can be
hard to get your answer.
log backups work properly. The copying of the logs from
Server A to Server B works properly, but it doesn't seem
to load the transactions into the database on the
secondary server. To test this I created a small table in
the database on Server A. I see the transaction log file
be created, be moved to Server B, but I never see the
table in the database on Server B.
terminate users in database checked). In the no recovery
mode, the database on Server B is always in a Loading
state and I can never look into the database to see if the
table was created (its a small table, 4 fields totally 80
characters).