I though that would work as well. However, as they do not appear under Users, the code gets rejected. I am now working on a script that the team can...

Thanks. That was the link I found. Guess I was looking for a "second opinion", just to be on the safe side. 🙂

Colin

It is interesting to note that when creating the SQL Job that you do NOT use the Powershell option but the Operating System(CmdExec) option and precede the command with Powershell.exe...

After much trial and error I have created a SQL Job which runs the following command. The Job states that it runs successfully, but no file is generated in the...

Thank you!

The mist lifts and the view is great.

Enjoy the holiday season.

Colin

Thanks,

Could you give a bit more information on how you store/run the script?

Regards

Have already checked the Protocol. Ckeck this out, which points me back to the Master Keys. \0ginal posting was at http://www.windows-tech.info/15/00680ec45b6aaa24.php

2007-10-11 02:52:40.15 spid5s Failed to check for new...

How about errors

"TDSSNIClient initialization failed"

and

"SQL could not spawn FRunCM thread"

Thanks, will see how we go.

The problem with the RESTORE MASTER KEY is that it runs in SQL, if I cannot get SQL to start then how can I run the SQL?

Platespin replicates the entire...

first error was

"An error occured during decryption"

followed by error

"failed to check for new installation or a renamed server at start up. The logic for this step has failed...

Thanks folks. A plan is starting to come together

Yes, I was thinking of detaching, copying the mdf and ldf files and then transporting these to the new location for reattaching to the new servers. Hopefully the copies wil...

Apologies for delay in posting final solution.

In the end I simply changed the Port number by running the following code. seems to have worked well.

ALTER ENDPOINT Mirroring

AS TCP (Listener_Port =...

Thanks, have been doing some research on this, following your guidance.

It seems that the Mirror Endpoint on both SQL Instances are using the same port number, which is not good....