I'm looking at using database mirroring and the "Failover Partner" parameter to help with the automatic updating of servers so I don't have to take the main application offline to run OS updates on the database server.
I believe the string would look something like this, but I can find any information on if Tridion Docs supports this set up-
Provider=SQLOLEDB.1;Password=isource-password;Persist Security Info=True;User ID=isource;Data Source=server-nameA;Failover Partner=server-nameB;Initial Catalog=database
Has anyone done a simple mirror/failover set up like this before and was it successful?