You're going do to what!?...hmm that might just work...

We are replacing our test SQL Server box with a nice shiny new one with lots of goodies..

The discussion commences with the script to restore or attach the databases back..

DBA 1: We don't need to do any of that!
DBA Others: What?
DBA 1: We'll do a default install, stop the service, copy the data (including master) and log folders over the top of the default directories and just start the service back up.
DBA Others:....(wild screaming, dancing and all round mayhem).....
DBA 1: Have you all finished?
DBA Others:....(wild screaming, dancing and all round mayhem).....
DBA 1: Have you all finished yet?
DBA Others: For the moment yes
DBA 1: AFAIK master contains all meta data about all the database right?
DBA Others: Yes
DBA 1: So what's the problem.
DBA Others: ... "Best practice"... "No Documentation on the process"..."You're f@#$ing mad"...
DBA 1: Look we have about 60GB of data, a Full Text catalog that will take about 40 hours to repopulate. I've done it before and I'm not wasting my weekend waiting for the "best practice solution" to finish.
DBA Others: How many time before?
DBA 1: About 6 times.
DBA Others: ...."We used to do it this way in Oracle sometimes"...."This ain't Oracle"...."I say go for it"

I'll give you an update after the fact....

Print | posted on Friday, February 20, 2004 9:46 AM

Feedback

# re: You're going do to what!?...hmm that might just work...

left by Clayton Firth at 2/20/2004 11:52 AM Gravatar
Just out of curiosity are you DBA 1 or DBA Others

# re: You're going do to what!?...hmm that might just work...

left by DavidM at 2/20/2004 12:06 PM Gravatar
Clayton,

I'm in the Others camp!...

# re: You're going do to what!?...hmm that might just work...

left by Enigma's Weblog at 2/20/2004 9:34 PM Gravatar
I would say that might work .. but then again .. you will need the same config regarding hard disks and all that.

Never tried it :)

# re: You're going do to what!?...hmm that might just work...

left by James Curran at 2/21/2004 2:31 AM Gravatar
Been there, done that (And it worked!)

Granted it was just my home system so if there'd be no bad deal if it crashed & burned, but, as it turned out, that wasn't a problem.

# re: You're going do to what!?...hmm that might just work...

left by Michael Teper at 2/24/2004 6:58 AM Gravatar
Dont forget that Windows Services info is not in the DB. In other words, make sure to migrate the account settings that SQL Server and SQL Agent run on (and dont forget to auto-start SQL Agent if you need to).

# re: You're going do to what!?...hmm that might just work...

left by DavidM at 2/24/2004 7:51 AM Gravatar
Michael,

Thanks for the tip Michael. Still waiting for this to occur, so I'll throw that info into the fire...

# re: You're going do to what!?...hmm that might just work...

left by Derick Bailey at 2/25/2004 12:30 AM Gravatar
We recently did a Backup and Restore onto a new server (which was identical in terms of hardware) and ran into some pretty significant issues: none of the SQLServer usernames had any passwords.

I'll be interested to find out if this works or not.

# re: You're going do to what!?...hmm that might just work...

left by Neil B at 2/25/2004 2:03 AM Gravatar
A Professional at work again!!!!!!!!!!!!!

So many options and the wrong one is top of the list.

# re: You're going do to what!?...hmm that might just work...

left by DavidM at 2/25/2004 8:30 AM Gravatar
Neil B,

A cryptic response, could you expand please?

Are you referring to the "drag and drop" approach?
Have you done this?
Which one is at the top of the list? And why is it wrong?

# re: You're going do to what!?...hmm that might just work...

left by crazyjoe at 3/19/2004 1:45 AM Gravatar
I guess the best answer to this would be (and I know this is crazy!!!)

Try it on a test system first? Document it well, be sure it performs as expected, and then get ready to put all the blame on DBA 1 :)
Comments have been closed on this topic.