restore system dbs to another server

Question

restore system dbs to another server

sqlfriend

SSC Guru

Points: 52794
More actions
December 10, 2010 at 9:11 am

#147894

We need to move a sql server 2005 to a new server. It's same version and sp.
The old one is a physical server, new one is a virtual server. (for some reason we cannot do a p to V move).
I can restore user databases to the new server.
For sytem dbs, I know we have an option of script logins and jobs then move them to new server.
But I would like to also know is there a step-by step instruction of moving sytem dbs to the new server? and if possbile to do it in managment studio?
Thanks

Viewing 7 posts - 1 through 7 (of 7 total)

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

Johan Bijnens SSC Guru Points: 135553 More actions · Answer 1

Is this a named instance or a default instance ?

IMO it should be doable for a default instance, provided you follow the "rename server" procedure sequence after you restored the system db.

Unless off course, your new virtual server as the same name as you current physical one. Then you can skip the rename server stuff.

Better read these first:

- http://msdn.microsoft.com/en-us/library/ms143799%28v=SQL.90%29.aspx

- http://msdn.microsoft.com/en-us/library/ms178083%28v=SQL.90%29.aspx

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

sqlfriend SSC Guru Points: 52794 More actions · Answer 2

Thanks, it's a default instance, no cluster, but what is IMO?

(we won't do other server to virtual server migration, because there is some windows server error on old server)

We will move databases manually.

My questions is is there a step-by-step instruction for restore sytem dbs.

Thanks

homebrew01 SSC Guru Points: 55553 More actions · Answer 3

IMO = In My Opinion

Others:

IIRC = If I recall Correctly

OP = Original Poster

FWIW = For What It's Worth

AFAIK = As far As I Know

etc...

http://www.gaarde.org/acronyms/

sqlfriend SSC Guru Points: 52794 More actions · Answer 4

Thanks,

So back to my question any step-by-step articles or white page about restore system dbs?

Is this a common task for DBAs?

Thanks

Jeffrey Williams SSC Guru Points: 90350 More actions · Answer 5

Anna_SQL (12/10/2010)
Thanks,
So back to my question any step-by-step articles or white page about restore system dbs?
Is this a common task for DBAs?
Thanks

I would say this is not a common task - most people build the new system, script out the jobs, logins, etc... and restore the user databases.

One thing you need to be very clear on is that maintenance plans will not work if you restore MSDB. This is because the maintenance plans are actually SSIS packages and the connection information is stored in the package (and cannot be changed). So, those maintenance plans will have to be deleted and recreated.

From my point of view - it is just as much work to restore the system databases and fixing everything as it is to just script out what you need.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

sqlfriend SSC Guru Points: 52794 More actions · Answer 6

Thank you! That's what I think too.

I asked this question is because a new network guy keeping telling me their previous company does this way, although I wonder if he knows how much percent of that and/or just heard of it. I did some research on microsoft site I cannot find a good knowlege based articles that describes steps to do this. And system dbs are important ones, I don't want to mess them up to an extent later I have to install sql server all from start.

Thanks