Geez sam, my head is spinning from that MS exam question of yours.

Tell you what... let's chop this up into smaller pieces and tackle it that way.

Ask me...

Well, don't forget also that your user mappings are going to be out of whack on the new server. They're mapped from each DB to the sid in master...

Well the fact that it's a wan is a lot less important than the speed of that wan. How does it compare with the rest of the lan?

And this...

No, restoring master is easy. Getting a sole connecetion to the server can be tricky.

Glad it all worked out.

You're entirely right. I misspoke.

That's because you're probably connected in Object Explorer too and when you open the new query window it makes another connection. Disconnect from object explorer and try to make...

The best you can hope for is to disable steps you don't want to run. You can change the start step, but everything after that will run so if...

Every DB can have only 1 trans log, though that log can be split into as many files as you like. This is to allow you to stripe them...

Start SQL in single user mode.

Open SSMS and restore using TSQL.

Here's the response I just got back from one of the devs at MS.

http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard

And did you do what it said and enable the XPs? What happened when you did?

Here's the code I use. Be sure to read the comments.

--Query for mirror status. This is how you check that the mirror is operational.

--This can be run from...

Try something like this...

--Manually Failover.

--Run on Primary.

ALTER DATABASE MirrorTest SET PARTNER FAILOVER

Yeah, when Yukon was released I gave a perfunctory effort to try to make that work, and lost interest pretty quickly. And while I haven't confirmed it in Katmai...

Yeah, VSTE is expensive(5K'ish) and powershell is free.

I'll try to get on here tonight or tomorrow and shoot a video on turning it into a process for you.