multiple Database mirroring in 1 server instance
Is it possible to mirror 3 databases on 2 servers,
ie. On server 1 database1, database2, database3
On server 2 mirrored database1, database2, database3
My admin claims due to endpoints its not possible to mirror 3 dbs from 1 server to another and one must use 3 serv开发者_如何学Cers each with 1 db...
Any help appreciated, also links
I have mirroring set up with 3 databases per server on MS SQL 2008. They're all using common endpoints, so I just have one endpoint on each server.
I'm also using a 3rd server as witness here, but that isn't very relevant, just to let you know that that too does work.
精彩评论