I have a production database, it has 20000 tables, 26000 indexes and 18000 views and triggers, stored procedures etc.
my user ask to have a database nearly 100% available as a sync copy of the production database . seems replication is only solution from database technology.
welcome any suggestion.
There is an upcoming class you might consider: CE243 "Using Queue Replication" beginning on February 14 in Baltimore.
I did watch some videos your posted :) they are really help.
I do have HADR, what we are doing right now by snapshot clone the STANDBY database to setup the reporting database.
But my user request a reporting database as fully replicating from production database near instantly , it is active to active, the source database has over 20000 tables. that I am concern the capacity of Q-Replication.
is there any third part active to active solution?