SQL Server Performance Forum – Threads Archive
Log shipping SQL 2005
SQL 2005I 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
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
http://msdn2.microsoft.com/en-us/library/ms190016.aspx
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
]]>