locked
SQL 2012 database migration to windows 2012 Server platform RRS feed

  • Question

  • How could we migrate existing SQL 2012 Standrad database on Windows 2008 R2 SP1 platform to windows 2012 R2 Platform. Will we need take any apecific measures while migrating. Can someone please let me know.
    Tuesday, June 24, 2014 4:53 AM

Answers

  • Hi,

    Since you are changing OS version here it has nothing to do with SQL Server. Get a new box install Windows 2012 R2 on it.

    Install SQL server 2012 standdard edition on this new server then move database system and user by backup restore mechanism. Backup and restore of system databases

    If all goes perfect decommision old Windows server 2008 r2


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    • Proposed as answer by tracycai Wednesday, June 25, 2014 3:05 AM
    • Marked as answer by tracycai Monday, June 30, 2014 10:49 AM
    Tuesday, June 24, 2014 9:09 AM