Restore SQL 2005 Master DB into SQL 2008 DB

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Restore SQL 2005 Master DB into SQL 2008 DB

Author

Topic

Thiyagu_04
Starting Member

37 Posts

Posted - 2010-04-06 : 02:25:47

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

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-04-06 : 04:07:40

I don't think it is possible.

MS SQL maintains lot of meta-data about the database (including the version it was created) in the master database's boot file and this information is read when you attach the database onto the server and checks against the version of the server.

The internal version is different than the version of the software like 2005 & 2008. when you attach the higher version database onto a lower then SQL Server fails the required validation. One of the reason is, the meta-data and the system internal tables and structures change from one SQL Server version to another and the lower versions can't handle the higher version structures.

Regards,
Bohra

I am here to learn from Masters and help new bees in learning.

Kristen
Test

22859 Posts

Posted - 2010-04-06 : 04:37:41

What do you have in SQL2005 Master that you want to "import" to SQL2008 Master database?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-04-06 : 11:54:26

^^ that's what i was wondering.

if it's user objects, then, well there's another good reason not to put 'em in master lol. script them out and apply the scripts to 2008 instance

Thiyagu_04
Starting Member

37 Posts

Posted - 2010-04-07 : 03:31:53

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.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-04-07 : 10:08:49

I think you can restore msdb, but i'd just script all the jobs and apply the scripts at new server. For logins, see these:

http://www.windowsitpro.com/article/query-analyser/sql-server-login-transfer.aspx

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56994

http://support.microsoft.com/kb/246133

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources