| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2009-04-15 : 08:23:40
|
| Dear All, Can any one provide me the steps for mirroring using sqlserver management studio wizard.as I get the error in performing it as belowMsg 1418, Level 16, State 1, Line 1The server network address "TCP://172.16.124.42.exensys.net:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.Msg 1416, Level 16, State 1, Line 3Database "M" is not configured for database mirroring. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-15 : 09:52:02
|
| Did you search in google before you post here? |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-04-15 : 10:16:18
|
| Have you used the Database mirroring setup wizard in SSMS to create the databases mirroring, and to be honest i think the faults says all you need to know, first one - happen you typed in the incorrect address and second one - the databases M is not the database configured for mirroring |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-04-20 : 08:36:05
|
| Dear All, I was struck in the mirroring error from one week,as I didnt get solution for the below error.How can we know which ports are free in sqlserver for configuring Mirroring.Please helpmeMsg 1418, Level 16, State 1, Line 1The server network address "TCP://172.16.124.42.exensys.net:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.Msg 1416, Level 16, State 1, Line 3Database "M" is not configured for database mirroring. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-20 : 10:19:05
|
| You can use "netstat" from the command line to view the currently in use ports. There are a few options you will need to use, it explains them if you do "netstat -?" |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-04-20 : 10:37:23
|
| Dear Tripodal, I saw the port using the netstat -an at the command prompt as 5022,but I still get the error when using the port 5022. |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-04-20 : 16:20:07
|
| Are you sure about the network address? It doesn't look right to me.__________________-An infinite universe is the ultimate cartesian product. |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-04-21 : 10:18:50
|
| Dear cat_jesus, The address was correct,but still same error. |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-04-21 : 11:09:22
|
| Dear Madam Tkizer, Please tell me the solution as I was struck with this error from one week.Msg 1418, Level 16, State 1, Line 1The server network address "TCP://172.16.124.42.exensys.net:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.Msg 1416, Level 16, State 1, Line 3Database "M" is not configured for database mirroring. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-04-21 : 16:03:04
|
| Assuming all the ports are correct (this can be confirmed in sys.TCP_endpoints), you need to make sure that you take a full backup of the database, then a log backup, and restore these both with NORECOVERY on the mirror partner server. Then you can use the ALTER DATABASE command to initiate the mirroring. The error that is given is unfortunately a bit of a catch-all error message. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-27 : 11:47:01
|
| This is not correct. usually.TCP://172.16.124.42.exensys.net:5022Try this "TCP://172.16.124.42:5022" |
|
|
|
|
Mirroring