Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Manually failover database mirroring Expand / Collapse
Author
Message
Posted Thursday, August 15, 2013 10:48 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:56 PM
Points: 1,015, Visits: 2,840
Thank you for replay

As per BOL, forcing service facilitates resynchronizing the databases (with possible data loss) when mirroring resumes and make it mirror database online..

Is it possible how much data cab be loss? after executed that statement

If we are using High safty mode in mirroring session not possible for data loss, It was two way committed transaction on both servers. Pl. confirm

rgds
anand

Post #1484977
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse