[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Failover steps for Log shipping

Shahar Mesika

3/29/2007 4:58:00 PM



Dear Team,


log shipping is enable on our db, created and restore transaction file
on Secondary server, all working good

how I can apply the transaction logs from the primary server on the
secondary server?

how I can switch the secondary db from read only to online production ?

Thanks in advanced

shahar.



*** Sent via Developersdex http://www.develop... ***
1 Answer

Uri Dimant

4/1/2007 9:51:00 AM

0

Shahar
http://www.sql-server-performance.com/sql_server_log_sh...

Hag sameah


"Shahar Mesika" <shahar@gns.co.il> wrote in message
news:%23sjFhNicHHA.5052@TK2MSFTNGP05.phx.gbl...
>
>
> Dear Team,
>
>
> log shipping is enable on our db, created and restore transaction file
> on Secondary server, all working good
>
> how I can apply the transaction logs from the primary server on the
> secondary server?
>
> how I can switch the secondary db from read only to online production ?
>
> Thanks in advanced
>
> shahar.
>
>
>
> *** Sent via Developersdex http://www.develop... ***