Moving your SQL install

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 1

And be sure you apply patches/SPs before restoring master adn msdb.

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 2

You're going to have downtime, so the easiest thing is to backup master and msdb.

Then detach all user dbs.

Now uninstall

Reinstall

attach dbs

restore msdb

restore master.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 3

Here's a few links to peruse before/during/after ...

SQL version checking:

(there's a more comprehensive link that includes 'hot fixes' but I cannot find it at present)

moving databases:

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

dok71 SSC Enthusiast Points: 173 More actions · Answer 4

thank for your suggestion.

I tried this but when I restored the master SQL would not restart because it couldn't find the model database.

Should I have restored this previous also along with msdb?

mark Jones-135146 SSC Rookie Points: 46 More actions · Answer 5

Your problem is your Model DB path has also been taken away, so SQL cant find it on startup.

If possible move the Model Db to the new Drive location - then take your backups of Master and Msdb and then perform your restores.

Look at MSDN for hint on how to move Model Db