Post reply

Installing SQL Server 2008 - features required to install on Production box

  • March 19, 2010 at 2:56 pm

    #386547

    Hi,

    I'm going to install SQL Server 2008 on new production server and I went through the link http://msdn.microsoft.com/en-us/library/ms143786.aspx and I want to know what FEATURES we can skip (Unnecessary ) and what must NOT to install on a Production SQL server box?

    Thanks

  • March 19, 2010 at 3:24 pm

    #1137048

    Do not install anything you do not need. If you are not using SSRS, SSIS, don't install them.

  • March 19, 2010 at 4:04 pm

    #1137071

    Thanks Steve,

    We are using maintenance plans for Maintenance tasks, so we need SSIS

    and we do not need SSRS & SSAS and I already skipped those. But my question is about the items under

    "Shared features" that will be required one on a production server? and among them, what shared features we should NOT be installed on production server

    thanks

  • March 19, 2010 at 6:27 pm

    #1137099

    pshaship (3/19/2010)

    Thanks Steve,

    We are using maintenance plans for Maintenance tasks, so we need SSIS

    and we do not need SSRS & SSAS and I already skipped those. But my question is about the items under

    "Shared features" that will be required one on a production server? and among them, what shared features we should NOT be installed on production server

    thanks

    SSIS was only required in SQL Server 2005 RTM - after SP1 the requirement for SSIS was removed. If you are not going to be running SSIS packages on that system, don't install Integration Services.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • March 20, 2010 at 12:50 am

    #1137151

    SSIS was only required in SQL Server 2005 RTM - after SP1 the requirement for SSIS was removed. If you are not going to be running SSIS packages on that system, don't install Integration Services

    I already have SSIS on SQL Server 2005 with SP3 and want to perform in-place upgrade to SQL Server 2008. So while installing SQL Server 2008, can I skip SSIS feature?

    Or uninstall SSIS from SQL Server 2005 first and then perform in-place upgrade to 2008?

    Which features under "Shared features" will be required to install on a production server? and among them, what shared features we should NOT be installed on production server

    thanks

  • March 20, 2010 at 8:23 am

    #1137176

    If it is already installed and you are upgrading - upgrade everything that is installed. If you are not using SSIS, you could uninstall it, but at this point I would just leave it and make sure it gets upgraded also.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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