November 14, 2005 at 5:12 am
I tried to establish connection between two endpoints (on principal and mirror) but mirroring couldn't started. Error 1478. I don't know what does it mean. I did everything described but... two endoints can't communicate.
Is it metter if one instance of SQL Server 2005 is Beta version (3) and other one is inicial release of SQL Server 2005?
April 5, 2006 at 2:25 pm
First of all, I would make sure you are running the same version of SQL Server on the Principal and the Mirror servers. (and Witness if you want auto failover)
Second, if you are running the RTM, make sure you have set the trace flag 1400 (i.e. add ;-t1400 to the startup parameters in SQL Config Mgr and restart the SQL Service on each SQL server involved, even the witness). This is documented in BOL.
Third, and this is why I got error 1478, backup the current TXN log on the Principal DB and copy and restore that log backup to the Mirror DB leaving the Mirror DB "non-operational" (restore options page) i.e. in NO Recovery mode (It should say "Restoring..." in SSMS permanently). The Principal and the Mirror DBs have to be the same before Mirroring can start.
Hope this helps...
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply