SQL Server Performance Forum – Threads Archive

Bringing the secondary database online

I had a database mirroring configured for a long time, the secondary server is in hot standby(restoring) mode, I decided to stop the mirroring and bring the secondary server online today, What I did is:
1. From primary server, remove mirroring, then do a transaction log backup
2. Copy the tlog to secondary server, restore the tlog with recovery option So far, the database is OK, I just wondering if I missed something? ——————
Bug explorer/finder/seeker/locator
——————

Can you see the database on secondary server ok?
If so then yesit is the procedure and make sure the logins are synchd anyway. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

After restoring the TLog file with recovery option from primary node, the secondly node is OK, I also checked the contents of both nodes, they are identical. ——————
Bug explorer/finder/seeker/locator
——————

Should be ok then, as an additional check you might refer to SQL Server error log. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

]]>