Post reply

Do i need to move system databases from 2008 to 2014 side by side upgrade

  • November 16, 2015 at 11:04 am

    #399333

    Currently i have sql server 2008 R2 and i am planning to move to SQL SERVER 2014.

    I am planning to do side by side upgrade.

    so,

    Steps 1:

    i made a full backup of user databases on 2008R2, and restored on 2014.

    Scripted out Jobs,alerts, operators, and crated on 2014

    transfer logins using SP_Help_rev-login (msdn) to 2014

    Created database mail, linked servers, Triggers on 2014.

    Configured Replication(push- transnational ) on 2014 same as on 2008 R2(X) ( from server X--Y and X--Z )

    my questions are :

    1.do i still need to backup master and msdb on 2008 R2 and restore on 2014?

    2.also i have distributor database on 2008R2(X) , do i have to move the from 2008R2 to 2014?

    please let me know

    Thanks in advance

  • November 16, 2015 at 11:23 am

    #1840061

    I wouldn't try to restore system databases to the new server as it could cause multiple issues when those dbs upgrade. You shouldn't really need much out of master, but you should script out all your server-level settings, logins, etc. so you can recreate them on the new server.

    The same with all your jobs, and any msdb-stored SSIS packages. Also, check model for any specific database settings that you may have set up in the past that you want to port over to SQL 2014. Again, scripting is your safer bet, and less likely to require an entire server rebuild if something goes screwy.

    As far as your distributor database goes, I'd advise just recreating your replication (via scripting or the GUI) on SQL 2014. Replication is going to break anyway (having two distributor dbs probably not the wisest idea), so you might as well break it in a controlled manner and recreated.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • November 16, 2015 at 11:41 am

    #1840070

    Thanks

  • November 16, 2015 at 12:07 pm

    #1840084

    Glad I could help.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • November 16, 2015 at 1:35 pm

    #1840129

    You can't restore master to a different version, it doesn't work. Script out everything (don't forget server config settings) and apply to the new instance. Only user databases should get transferred.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 16, 2015 at 1:59 pm

    #1840148

    monster,

    thanks for the tip..i am looking at below link per your suggestion on scripting config settings

    http://blogs.msdn.com/b/john_daskalakis/archive/2014/10/27/script-to-export-the-configuration-of-sql-server.aspx

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

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