You can also do a backup/restore or detach/attach on the production server, but be sure that it's what you really want to move.

There are also compare tools, like SQL Compare...

I still like WayneS' avatar the best.

I had someone reply that if you removed the mirroring ports from the witness (endpoints), it would be available to be set back up again.

I'd do this with scripting, as that could easily be embedded in an SSIS package if needed.

I'd do my backup on the first server, using a separate file/name for each...

I'm assuming you mean you want to remote mirroring from the witness, when it's not connected to the other servers?

I haven't found a process for this. Still looking. Everything says...

I think Lutz has some bad karma going. It seems every weird thread I come across with a difficult OP is one in which Lutz is answering. :w00t:

The forum code is integrated into the rest of the site. Probably some breakage there.

Yes it can. Any number of things are read from the registry during boot and if it's messed up, you can be stuck with a server you cannot recover.

backups would...

I believe a visit is a login/session. So you can view multiple pages, or post multiple times per visit. It's not pages you've viewed.

We also give points for the question...

Giddy up? Like this:

Or this? My wife got me out this weekend

That should work. AFAIK, the database version is the same on SQL 2005, regardless of Service Pack.

The x86 v x64 matters a lot here. Also, are you sure this instance of SQL is configured for 8GB? What's shown (Exactly) if you run sp_configure for this instance.

Great job, and a very nice read.

http://msdn.microsoft.com/en-us/library/ms188917.aspx

So you have the basic advice. Here's what I'd recommend you do right now:

1. First, make sure that you have a good full backup.

2. Switch to simple mode, then back...