* If you question is to do automatic redirection between publication DB and subscription DB, the answer is NO for SQL 2005.
Sunday, March 11, 2012
Automatic client redirect in SQL Server 2005
Will this work with replication too. I see it with a mirror database, but could it work if I was keeping two copies of the database and wanted to transparently reroute the connection to a surviving server?We will support such redirection on the publication database, when DB mirroring becomes a supported feature later.|||* If the publication DB is mirrored, client can do automatic redirection between the database on principal server and database on mirror server. BOL has a topic called "Replication and Database Mirroring" on this. As Li said, it will be supported once DB mirroring becomes supported feature.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment