thanks. i need some sanity check here...
i failed over from my principal (SERVER1) to mirror (SERVER2), now the mirror is the principal.
On SERVER2, i ran the stored proc sp_add_log_shipping_primary_database and sp_add_jobschedule. it creates the jobs and they are running fine (log backups are created).
On SERVER3, my DR server, i run sp_add_log_shipping_secondary_primary and sp_add_jobschedule. it creates the Copy and Restore jobs (copies logs from SERVER2).
On SERVER3, i run the sp_add_log_shipping_secondary_database but the database already exists because it was created when i set up log shipping on my original principal on SERVER1.
Msg 32013, Level 16, State 1, Procedure sp_add_log_shipping_secondary_database, Line 80
A log shipping entry already exists for secondary database MIRRORTEST.
Am I supposed to delete and recreate the log-ship database MIRRORTEST on SERVER3? Doesn't seem right. What am I missing?
If I wasn't clear before...at the end of the day, I want to log ship from SERVER1 TO SERVER3 when SERVER1 is principal and from SERVER2 to SERVER3 when SERVER2 is principal (after failover).