Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 mssql 2005 database mirroring, wondering anyone have done this

views
     
TSnxfx
post Mar 3 2006, 12:47 PM, updated 20y ago

Enthusiast
*****
Senior Member
979 posts

Joined: Jan 2003


Anyone have done this before?
If I setup server1 to mirror server2, would server2 mirror to server1?
If the server1 is down the app will connect and do transactions on server2.
But if the app connect to server1 will the server1 has the same info as server2.

Any comments,suggestion or idea is much appreciated.
Hou_JaI
post Mar 3 2006, 06:42 PM

Regular
******
Senior Member
1,129 posts

Joined: Jan 2003


As far as i know from the theory part of this feature,

server 2 will have the most up to date data. it checks if server 1 has new data or not, then make a replicate of the data itself (not all of it) into server 2.





 

Change to:
| Lo-Fi Version
0.0280sec    0.77    5 queries    GZIP Disabled
Time is now: 23rd December 2025 - 11:40 PM