I'd recommend a side-by-side.  This way you can test everything as you move it and if the move doesn't work, it's a work of moments to turn the old database...

Named Pipes is not strictly necessary for SQL Server 2005 to run.  Unless, of course, you don't have any other protocols set up.

Also, sometimes weird errors happen when you don't...

I agree with Jack and Ninja.  When I need to restore a table (or even part of a table) that has been deleted, but not mess anything else up, I usually...

James, I think your advice is a little bit off.  Once the FULL backup is restored, Subu only has to restore the most recent Differential backup and then all the...

Chris,

I don't think this guy is being rude so much as he's being confused.  After all, the interview process is over and someone else has been hired.  Depending on what...

But only working with agencies that are reliable and polite is not the same thing as being beligerent or rude to a recruiter or potential employer.  I'm sure, Matt, that you...

For MCTS, yes, there is only one test and it is the above test (see http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx for more details). 

Unfortunately, the MCTS is like the original MCP.  It's not worth...

I feel for you, David.  Things like that are reasons why I don't personally believe in boot camps.  They take your money but they don't actually teach you anything.  They...

bytezone,

Motivation tends to be personal and without knowing you, it's hard to know where to start.  Tell us why you started prepping for the test in the first place. 

Thank you again for your reply, Markus.  Now the author's statement makes complete sense. @=)

Markus,

Ah... I forgot about service pack installs.  But, won't an install of SP bring down the mirror for about the same amount of time?  After all, if you have to...

Loner,

Is this the same job you've posted about in other threads?  If so, I recommend you polish up your resume and hunt for another one because it seems this job...

Don't worry, Steve.  I'm not blaming anyone whose name isn't on the cover. @=)

Actually, your last statement makes a lot of sense.  That explains why this book has got me...

And don't forget, in SQL Server 2005, xp_cmdshell is disabled by default.  If you haven't configured it to be active, check your SQL Server Surface Configuration.  BOL also has a...

Hmm.  I've just realized why I'm being so petty about this.  When I read books like this I tend to evaluate them for later recommendation.  And here's what I've found:

This...