Wednesday, March 7, 2012

DB mirroring setup

Prepare to setup DB mirroring. Three MS 2003 servers. Two SQL 2005 standard edition as partners and one SQL 2005 Express as witness. Question:

1. Servers are under workgroup (not domain user). Is it ok to use local service account to run DB engine service on all three machine? Is SQLServerAgent service required when setup mirroring?

2. If SQL Server is running as a local service, Do I have to manually create certificates before setup mirroring?

3. After create certificates, can management studio be used to create endpoints on all three machines? If yes, how to select certificates that have been created? If no, can management studio be used to setup mirroring after endpoints have been created?

actually i'm also would like to know about the additional settings if there is. Hope can get some guidelines here. Thx

Best Regards,

Hans

No comments:

Post a Comment