Log shipping SQL 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Log shipping SQL 2005

SQL 2005
I have a DB set up for log shipping, A ships to B
the backup DB ‘B’ stays on a status of "restoring"
what is the method for cutting over to the log shipped DB ‘B’ and bringing it online for use? Thanks,
Only in case of any issues on Primary server you would need to get the server B to get online.
Have a look at Log shipping topic under SQL Server 2005 books online. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Mohammed U.
You can change the log shipping properties to set the remote server as "Stand-by" mode if you want set the remote server as Read-Only mode so you can read the data in the secondary server Hari Devarakonda