Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2007-11-20 : 05:00:17
|
| Hi Experts,I have configured mirroring and its working fine. But in an article from microsft I came accross a line" • The principal database must be in the FULL recovery model. Log records that result from bulk-logged operations cannot be sent to the mirror database. "But when I do a BCP, Select into or Bulk insert to the principal server I can still see the changes/or new rows inserted in mirrored database's snapshot. How is this possible?Please help. Thanks in advance.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
boobala_k
Starting Member
1 Post |
Posted - 2007-12-12 : 05:45:53
|
| When i config for mirroring i got the following error messaege pl help meMsg 1418, Level 16, State 1, Line 1The server network address "TCP://boobal.sakthi.Local:10112" 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. |
 |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2007-12-12 : 06:16:48
|
| boobala k,Check whether your SQL Server is running under Local System account. If yes, change it to domain account.Suresh B. |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2007-12-12 : 06:35:06
|
| http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspxCheck this. It helped me to fix the problem. The error msg is actually misleading. The above linked helped me and fixed my issues.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
|
|
|
Mirroring Help