If you have the ldf/mdf, I'd try attaching first. If that doesn't work, then try the restore.

Michael,

Thanks for the response and let me say that I like your version better (sorry, Shaun). I wasn't aware you'd written it and I've been on SQL Team a good...

Don't have to burn anything to generate power. Go nuke, I'm with David on that one.

Global warming, we'll never agree, as on a few other issues. Doesn't mean we shouldn't...

A flawed concept, perhaps, maybe even probably. I wish we could band together and better use our resources.

In studying economics, one thing I've learned, or think I have, is that...

I'd agree with George. Data/log separation isn't necessary for system databases. Or if it is, you're likely doing something strange in there.

Yikes, get back to energy. Ignore the politics for now. We all have opinions on the matter, and they are that, opinions.

I'm not convinced of global warming, but I do...

Advantage, it seems simpler to do backups. They point to an instance and it backs up.

Disadvantages: the restores don't always work. I've had them flake, they can be slower, and...

There are some resources on the MS site.

Dumps/specifics from the exam are illegal and violate the NDA. We don't condone those, and MS will revoke your certification for using/posting those.

Pick...

2008 is stable, but you have to decide that.

Either one works, there's no compelling reason to say 2005 or 2008 unless you need some specific feature in 2008.

Find SPID (sp_who2) that is running this.

kill (spid)

look at this

http://www.sqlservercentral.com/scripts/Miscellaneous/30473/

you might have to fix users/logins as well.

You should follow Gail's links and check out the various ones offered and decide which one fits what you do.

also, moved to the certifications forum.

watch memory. You'll have some management work do to there to figure out how much each instance needs.

You can install SQL anywhere (the program files) and set the data files anywhere as well. You can move data files (detach/attach), set defaults for new databases, or ad hoc,...