November 11, 2008 at 2:11 pm
Hi Experts,
I have 6 databases ( A, B, C, D, E, F) on a single server ( Server1) and i have an another server ( Server2) which also has database A and now i would like to do database mirror operation on only one database ( for eg A) from Server2 to Server1, is it possible without worrying about the db's like B, C, D,E and F.
If it is possible then would it be risky to do that as these db's are very important for the bussiness operation.
Thanks
November 11, 2008 at 2:49 pm
Mirroring is database specific it has nothing to do with rest of the B,C,D databases for which its not being configured. Also, the source database in mirroring is available for user requests and the second copy of it on other server remains in inaccessible state.
MJ
November 11, 2008 at 7:15 pm
Mirroring is used as a High Availability technique, not risky I must say. But you cant configure it for high performance also.
Check DB Mirroring in BOL for more details.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply