Post reply

Upgrade SQL Express to Enterprise

  • April 27, 2016 at 4:22 pm

    #307046

    Hello I need your support

    Currently I have a server with the next version

    Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

    Feb 10 2012 19:39:15

    Copyright (c) Microsoft Corporation

    Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

    I want to upgrade this Express Edition to enterprise but I got an error message ( failed to retrieve data for this request) when I execute Maintenance\Edition Upgrade

    I'm not sure about the correct method

    Please help me

    Thanks

  • April 27, 2016 at 5:30 pm

    #1875121

    there's no upgrade path for Express to non express versions; instead you need to backup all the databases, script out your logins, as well as anything server related...certificates, linked servers, etc.

    then uninstall sql express, install the non express version, and restore the databases, and runt he script sot put those users and objects back.

    it's actually good disaster recovery practice to have to do this.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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