How to restore SQL 2005 Master DB into SQL 2008 DB

Question

How to restore SQL 2005 Master DB into SQL 2008 DB

Thiyagu-343189

SSC Veteran

Points: 209
More actions
April 6, 2010 at 12:54 am

#231382

Hi
Is it Possible to restore SQL 2005 Master Database into SQL 2008 Master Database.If yes please let me know how to do that.
Thanks in advance

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

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

BrainDonor SSCoach Points: 19254 More actions · Answer 1

No.

The Master db stores the system-level details of the SQL Server system it is installed on, so you wouldn't want to do such a thing. Have a look at 'Master Database' in BOL.

Why are you considering it?

BrainDonor.

Steve Hall
Linkedin
Blog Site

Paul White SSC Guru Points: 150467 More actions · Answer 2

Thiyagu-343189 (4/6/2010)
Hi
Is it Possible to restore SQL 2005 Master Database into SQL 2008 Master Database.If yes please let me know how to do that.
Thanks in advance

AFAIK the only supported way to do anything like this is as part of an overall upgrade from 2005 to 2008 using the 2008 installation program.

Like Mr Donor, I am fascinated to hear why you ask this question.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Thiyagu-343189 SSC Veteran Points: 209 More actions · Answer 3

Not only master DB i want to restore all system DBs

I want to retain following informations such as

1.SQL Server logins and the passwords which needs to be transferred

2.SQL Server Agent related to data such as Jobs, alerts, Operators, Maintenance plans etc.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

I would do it using the upgrade option with SQL Server, as Paul suggested.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Paul White SSC Guru Points: 150467 More actions · Answer 5

Thiyagu-343189 (4/7/2010)
Not only master DB i want to restore all system DBs
I want to retain following informations such as
1.SQL Server logins and the passwords which needs to be transferred
2.SQL Server Agent related to data such as Jobs, alerts, Operators, Maintenance plans etc.

This just sounds like an ordinary instance upgrade...?

Unless you state why you want to do what you ask, it is difficult to add anything...

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Thiyagu-343189 SSC Veteran Points: 209 More actions · Answer 6

Along with SQL 2008 instance i need to have SQL 2005 instance too.

If i doing upgrade from 2005 to 2008 whether i can have sql 2005 instance.

Paul White SSC Guru Points: 150467 More actions · Answer 7

Thiyagu-343189 (4/7/2010)
Along with SQL 2008 instance i need to have SQL 2005 instance too. If i doing upgrade from 2005 to 2008 whether i can have sql 2005 instance.

Not if you upgrade it in place, but there's nothing stopping you taking a copy.

General information here: http://msdn.microsoft.com/en-us/library/ms144267.aspx

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi