Post reply

Sql Server downgrade.

  • June 16, 2009 at 6:50 am

    #201408

    Hi,

    We are having a Server with Sql server 2005 Enterprise Edition

    and are about to downgrade it to sql server 2005 Standard Edition.It

    has around 50-60 users ,40 SSIS Packages and a few link server and asymmetric keys.How can i take all the detailed information about the user,packages and their access to database.

    Regards

    Prasanna

  • June 17, 2009 at 1:23 pm

    #1011223

    We had to do something similiar. We backed up the master and msdb databases, then detached all the user databases. We de-installed SQL Server EE and installed SE. We attached all the user DBs and then restored MSDB and Master. This should get you started.

  • June 18, 2009 at 3:39 am

    #1011564

    Hi,

    By restoring the master and the msdb are you sure that the

  • June 18, 2009 at 3:40 am

    #1011567

    Hi,

    Are you sure that by restoring the master and the msdb database

    we can have encryption functionality working properly.

    Regards

    Prasanna.

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

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