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 derrickleggett@hotmail.com When life gives you a lemon, fire the DBA.