We are thinking of implementing the databases mirroring as hot stand by for all the databases in the same site on two powerful servers.
Right now we have two server : 1. Svr1 with 7 small databases and 1 VLDB (550 GB --1 year data ) ---total 8 db's.
2. Svr2 with 1 100 GB( 1 year data --Crucial database) and 1 small db---total 2 Db's.
We want to migrate databases on these databases on these 2 old Servers to two new powerful servers and also we want to divide 10 databases on the 2 new server in such a way that every 1 database on new Svr1 will have a synchronous mirror on the
Svr2 and every database on Svr2 will have synchronous mirror on Svr1. Database mirroring is going to synchronous on all the databases and with a separate witness server which will on cluster to prevent the single point of failure for the automatic
What do you guys think of it any suggestions ........
how database maintenance jobs works in mirroring.....if suppose rebuilding an index online takes 20 min....how it will be effected in mirroring ....???
how n/w is going to effect ...how should we configure the n/w in same site ....what do you say if w
View Complete Post