• Perry Whittle (1/20/2012)


    kellithompson (1/20/2012)


    Yes it is. It's off-site at another location, but it's the same domain.

    That makes things a whole lot easier. Just set mirroring up as defined in BOL. I have a script which you can use if you want it.

    Thanks Perry, I would like a script. I just wanted to test if I could get a mirror to work between my clustered instance and an offsite instance. I followed the BOL in creating a new database on my primary. Created a table and added some rows. Backed up the DB and the log fille using the proper method. Restored both w/ NoRecovery. Made sure I could telnet to both primary and mirror server on my designated port. I cannot get past the famous 1418 error w/ severity 16, state 1, line 1. I have removed all the configurations and started over 3 times and I must be missing something simple because each time I get the same error. Let me know if you have any advice.

    Thanks in advance. KT