You are misleading people. You are not changing the instance name. You are only changing the server name as known to SQL Server. Please be very careful...

This response was quickly typed and might have errors in it. Oh, and I should add the usual disclaimer ... your mileage may vary.

I can only speak to...

What was the actual solution?

I found a solution then had to abandon it. The problem I was dealing with was that the Sharepoint and app DBs in Project Server and Team Foundation Server...

Yes, but do a copy action not a move action, to ensure the destination folder's security settings are applied to the files. The DBA team I am part of...

Ah, so he did. Clever fellow. :hehe: I will edit the post to remove the "please credit me" comments.

(ignore this)

HOW TO ELIMINATE THE NEED TO REBUILD THE MASTER DATABASE

You can create copies of the system DB files while SQL Server is running. 😎

Enhance your daily backup job such...

No it hasn't. In a MOPS configuration, with SS2008R2 installed with default collation, many databases are configured with a different collation. The result is the same symptom described...

Perry, that was an excellent tip! Thank-you.

So if you have a filecopy of the resource database saved away

...

a recurring weakness in MS documentation in that it does not always tell the full story or reflect...

Ian,

Thanks for your feedback. I think you offer a concrete case for the type of standardization I am hoping to achieve. (One of the first things I did...

That's a nice little trick to have in one's back pocket!

I know a similar trick you can apply to a log shipping target database to verify it's integrity,...

LOL! I just realized "Ten Centuries" is a descriptor, not a handle. DOH!:D

It now seems clear that I need to be prepared for a REBUILD or re-install in...

I hadn't thought of calling the maintenance plan from the hand-written SQL Agent job that calls the script. That just might fit the bill. Thanks!

Unfortunately, powershell is not...