restore with recovery and log shipping

[alex]

hello everybody

I have custom log shipping .
it run every 15 min

DB1 located on Server1
DB1 backup logs to server 2

DB2 located on server 3(300 km away from server1 and server 2)

Db2 restore logs from server 2

If server1 and server2 become unavailable
1.
Would enough login to server3
and
run
RESTORE DATABASE Db2
WITH RECOVERY

to bring db from read only to production mode up last restored log?

Thank you
Alex

[skhanal]

That's right.

You need to make configuration changes in your application to point to the new production server.

You may also have mismatched login/database users. You can fix that using sp_change_users_login procedure.