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 derrickleggett@hotmail.com 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.
