What you probably want for complex lookups is an SSIS package that moves data from server A-> B. Then another package to move from B->A. However you'll need to somehow...

I think you are missing files or the download was corrupt. There isn't much we're going to be able to do if you don't have a good download.

You can write a query or view to change data around and handle some simple transformations.

Without knowing more about what you mean, it's hard to recommend something.

I think anything you...

Replication will do this, and you can transform the data somewhat on either side.

I think you're stuck with uninstall/reinstall.

There are a few blog applications out there, like .Text from Microsoft that you can download and examine the schema.

Can't be done.

Detach dbs, script logins, uninstall, reinstall.

This doesn't really matter, as long as you have the paper to support what you are running.

If you are doing this because you need to move the CPU license to...

There are multiple versions now, a light version (LT) that's smaller, a datawarehouse version, the regular one, etc.

Do it for one server, then build a set of scripts to pull this together. It sounds like busy work, since this is just documentation and the location can change...

It used to be that when you deleted a database file, the physical files were not removed. so you could attach them again. That doesn't happen any more.

The mirror database should be in the restoring status. It is in that state so that new logs can be applied to the database.

If the principal goes down, then you may or may not be able to get a mail.

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

http://www.petri.co.il/mount_iso_files_in_windows_vista.htm

http://lifehacker.com/180124/mount-an-iso-file-without-burning-a-disk

didn't notice the comma, but I realized the intent of the question.