SQL Server Performance Forum – Threads Archive

restore log

If the primary server is out of service suddenly, the secondary server will act as primary server. if the last transaction log had been restored, how to make the loading database to operational mode on secondary server

On the secondary server: RESTORE LOG [dbname] WITH RECOVERY Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

is it ok to restore the db with recovery by GUI without specify the last transaction log providing that the last transaction log had been restored

? Just do it in QA using the script Satya gave you. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

]]>