Sql Database Mirroring in a workgroup

mirroringsqlworkgroup

I found an article explaining almost everything I need to know here:

http://www.sqlservercentral.com/blogs/kendalvandyke/2011/12/01/database-mirroring-in-a-windows-workgroup/

The only difference between my scenario and the one in the article is that I am using a witness. That said, I'm wondering which service accounts should go in the Principal, Mirror, and Witness text boxes or if I will have to create the endpoints manually myself. And if I will need to create them myself then I could use some help figuring out what the sql statements would need to look like.

Best Answer

The service accounts they are referring to are the accounts that the SQL database service is running. In my experience I've never had to manually make the end points, but it's not difficult.

Here's the rundown on creating the endpoint: http://technet.microsoft.com/en-us/library/ms181591.aspx

Related Topic