if the chickens don't predict the future, you can still eat them!

And this is why I decided not to pursue medicine.

Actually, scary, and perhaps inevitable

..........

If it was only so easy

Farhan, thanks for the contribution.

No doubt it will nudge many to make the move to mirroring. And for those that have not started to use mirroring, get going....

Yes, It's my understanding that Bill Gates will be named the first President of the combined organization.

Lets welcome Bill!

Phil,

Thanks for keeping this topic alive and well. Oh, the many times I've heard:

"...who needs recovery, our servers never go down..."

Yea, right.

True Story: Once in...

Good intro.

MVCC (multi-version concurrency) is a major addition to SQL Server.

I encourage everyone to fully understanding the differences between Read Committed Snapshot, and SnapShot Isolation. Miss-use of...

good to know, good to watch.

-- years ago, MS had the terradata server running MSSQL 6.5 for the satellite pics. No sure what ever happened to it. but was...

Jason,

Good stuff, and thanks for taking the time to research and write.

This adds to the collective knowledge!

yea, the scripts are not a total guide. For logins, a good way to go is to just use a single login for all servers. in this case,...

some of the script was cut off:

To change or set mirroring endpoint config:

ALTER ENDPOINT Endpoint_Mirroring

STATE = STARTED

AS TCP (LISTENER_PORT = )

FOR database_mirroring (ROLE = ALL);

GO

To...

Below is a set of steps I use to setup mirroring with a cert.

I have not seen your specific issue, but I don't setup mirroring everyday.

Keep at it, it is...

Points for finding a solution to your design problem.

I hope to never have a client with such a disaster.