Thycotic Community Forum

3/23/2010 7:49:54 AM chvgms Posts: 14	Hi, I have configured DB mirroring for my existing secret server for the DB failover with witness server. My question is what is the order do i need to follow if i want to reboot the primary, secondary and witness servers? Thanks, Sridhar
	0 • link
3/23/2010 11:51:37 AM Tucker Posts: 87	Hello Sridhar, To reboot machines in a mirrored environment you will need to temporarily pause the mirroring. If you go to database properties and the Mirroring tab, there will be a Pause mirroring button. Once paused the machines can be rebooted and then when they are all back online the mirroring can be resumed. While the mirror is down the primary will queue a log of any changes and when the mirror is resumed these will be replicated to the mirrored database. If the outage is going to be prolonged, you may need to remove and recreate the mirror rather then pausing because of the log size. See this link for more information: <a href="http://www.thycotic.com/products_secretserver_forums.html?postid=1776#1776">http://www.thycotic.com/products_secretserver_forums.html?postid=1776#1776</a> -- Regards, Tucker
	0 • link
4/12/2010 2:33:46 AM chvgms Posts: 14	Hi Tucker, Since the DB mirror is very much controlled by witness server, in the event if it crashes, the DB on the primary cannot be accessed nor deleted. What would be the alternative to access the DB in this case, apart from creating a new DB, restoring the backup and configuring the new DB name in the configuration settings? Thanks, Sridhar
	0 • link
4/13/2010 6:25:29 AM Tucker Posts: 87	Hello Sridhar, In the event the Witness Server goes offline and the primary gets in the fail-over state. You can disable mirroring and then continue to access the primary database. 1. Run this SQL command on the primary db to disabling the Mirroring: ALTER DATABASE SET PARTNER OFF; 2. To Disable the Database's Recovery State (Restoring) Run this command: RESTORE DATABASE WITH RECOVERY; -- Regards, Tucker
	0 • link
4/13/2010 6:25:40 AM Tucker Posts: 87	Hello Sridhar, In the event the Witness Server goes offline and the primary gets in the fail-over state. You can disable mirroring and then continue to access the primary database. 1. Run this SQL command on the primary db to disabling the Mirroring: ALTER DATABASE SET PARTNER OFF; 2. To Disable the Database's Recovery State (Restoring) Run this command: RESTORE DATABASE WITH RECOVERY; -- Regards, Tucker
	0 • link
7/13/2010 8:24:25 AM chvgms Posts: 14	Hi Tucker, Today I had an situation, where the witness and secondary at DR site went offline due to FW maintenance). The DB on the primary was not accessible using web though I have disabled (Paused) mirroring on the primary before the Firewall went offline. How do i make sure that the secret server is accessible in such situations? Thanks, Sridhar
	0 • link
7/14/2010 6:06:42 AM Tucker Posts: 87	Hello Sridhar, This MSDN document has details for maintaining the SQL server connection when the Witness or Secondary server need to go offline: <a href="http://msdn.microsoft.com/en-us/library/bb677181.aspx">http://msdn.microsoft.com/en-us/library/bb677181.aspx</a> -- Regards, Tucker
	0 • link

---