Maintenance Plans missing

  • A third party has updated a SQL Server 2005 installation to SQL Server 2012. I am maintaining the SQL Server DB's and front end remotely. I wish to recreate the DB maintenance plans and jobs, however these are no longer available in SQL Server Management Studio. I suspect the third party did not install Integration Services and or Analysis Services. Am I able to post install these services and how as I will need to advise the third party. Any assistance gratefully received.

    Thank you

    Neil

  • Neil

    Yes, you can add those components. Start by running setup.exe and click on Installation, then New SQL Server stand-alone installation or add features to an existing installation.

    John

  • Many thanks John, will advise the person who installed the new sysytem.

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

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