I'd also recommend that you pick up a copy of Grant's book to help you better understand.

*= is a left outer join. You'd convert this as'

select a.customer, b.order

from customers a, orders b

where c.customerid *= b.customerid

to

select a.customer, b.order

from customers a

left outer join...

Here are a few more:

http://www.sqlservercentral.com/articles/Administration/customlogshipping/1201/

http://www.sqlservercentral.com/articles/Log+Shipping/70506/

First, never grant privileges to users. Create a role, grant rights to the role, add users to the role. You do this for the exact reason that you are trying...

While I haven't used BackupExec 12, I've had experience with 11, 10, a few other versions. I've always had issues doing restores with BackupExec, especially when I had a disaster.

As...

I've seen both. I like the crossover cable since it's easy to setup and less to break.

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...