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.
| Author |
Topic |
|
mp5387
Starting Member
2 Posts |
 Posted - 2014-06-24 : 23:10:30
|
| Hello everybody. I am going to restore my master, model, msdb, and tempdb from my previous MS sql server 2008 r2 to the new MS SQL Server 2012 r2. Is that possible, or not?Thanks for your answer!!MP |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-25 : 01:47:59
|
| The system databases are designed to work with the current version, therefore the sql server 2008 r2 system dbs, work with sql server 2008r2.To migrate objects , such as jobs, backup history etc, think about scripting these moves to sql 2012Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-06-25 : 03:41:17
|
There should be a like to button,so that we can like good posts like this..:)quote:
Originally posted by jackv
The system databases are designed to work with the current version, therefore the sql server 2008 r2 system dbs, work with sql server 2008r2.To migrate objects , such as jobs, backup history etc, think about scripting these moves to sql 2012Jack Vamvas--------------------http://www.sqlserver-dba.com
Javeed Ahmed |
|
|
|
mp5387
Starting Member
2 Posts |
Posted - 2014-06-25 : 12:48:08
|
| So, I decided to install MS SQL server 2008 on my new server. Do we need any order to restore system database, and database for the application?Thanks for your anserMP |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-26 : 01:33:34
|
| @mp5387 - could you clarify - are you trying to migrate from sql server 2008 R2 to sql server 2008?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-07-09 : 07:13:46
|
quote:
Originally posted by mp5387
Hello everybody. I am going to restore my master, model, msdb, and tempdb from my previous MS sql server 2008 r2 to the new MS SQL Server 2012 r2. Is that possible, or not?Thanks for your answer!!MP
No its not possible to restore system databases of one SQL server version on system database of different version . Hope your destination database is SQL Server 2012. There is no R2 version.You can restore master database from 2008 r2 as a normal database on 2012 but not on master database of 2012.RegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
|
|
|
|
|
RESTORE DB FROM 2008 to 2012