Post reply

SQL Server upgrade from 2008 to 2012 and migration to new server

  • August 8, 2015 at 11:42 pm

    #301157

    Hi All,

    We are planning to migrate our SQL Server 2008 R2 instance which is on below verion, to SQL Server 2012 enterprise edition. SQL server 2008 R2 instance is shared environment which host many databases with different applications.

    We are also migrating to the new box with latest windows server.

    Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

    I want to know what changes from database side and from SA team needs to be done so that all the applications can connect to new instance on new box at cut over date.

    Thank You !!!

    Regards,

    Akshay.

  • August 9, 2015 at 12:09 am

    #1818387

    Here is an article detailing some of the new stuff.

    https://technet.microsoft.com/en-us/library/Bb500435(v=SQL.110).aspx

    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

  • August 10, 2015 at 6:57 am

    #1818523

    Here is almost all you need to know

    SQL Server 2012 Upgrade Technical Guide

    https://msdn.microsoft.com/en-us/library/dn144931.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

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