SQL Server Performance Forum – Threads Archive

Log shiiping process

Hi, If my production server is up then can i able to remove read only tag of database which resides on stand by server.

RESTORE database WITH RECOVERY After you do this, you can’t restore any more transaction log backups though. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Log shipping is a very useful method of creating warm standby failover server as well as providing separate reporting server. Using this feature can provide significant benefits in relevant business scenarios. But ensure users are disconnected from standby database, when the next schedule of Log shipping is trying to restore the transaction log. Otherwise the jobs will fail. If subsequent RESTORE operations (RESTORE LOG, or RESTORE DATABASE from differential) are planned, NORECOVERY or STANDBY should be specified instead. 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.

]]>