December 14, 2015 at 1:01 am
Hi Guys,
I have created a mirror on a database where the SQL Server service is running on a domain account.
I want to ask the IT guys to change the password and make it static.
What would be best practice in changing the password without breaking the mirror.
Would I have to pause the mirror then change the password and then start the mirror again?
This is a very high volume transactional database so I can't let the mirror database fall behind too far.
December 15, 2015 at 6:38 am
all you need to do is change the service account password to its new value via SQL configuration manager (it MUST be done via this tool) and then either wait for a normal scheduled restart or restart at the time.
no need to do anything with mirroring, order of restart doesn't technically matter but i guess do mirrorred server first for safety's sake.
---------------------------------------------------------------------
December 15, 2015 at 6:50 am
Thanks for the feedback I really appreciate it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply