Link to home
Create AccountLog in
Avatar of dankyle67
dankyle67

asked on

modifying maintenance plan in sql server managment studio 2008

Hi,
been trying to modify an existing maintenance plan i set up so i can change the target drive and was told that in sql 2008 cannot do this if install of sql mgmt studio was installed in basic mode instead of complete install.  This is probably correct but any other way around this since i currently do not have access to the sql 2008 cd so cannot uninstall the basic edition of sql mgmt studio.  If i cant modify it is there a way to at least view what target directory the backup is set to?  thanks
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Since there is no "basic" or "complete" mode, I can only suspect you are using Microsoft SQL Server Express and are referring to the Microsoft SQL Server Express with Advanced Services, if that is the case you can certainly download it from here:
Microsoft® SQL Server® 2008 Express with Advanced Services
http://www.microsoft.com/en-us/download/details.aspx?id=1842
Avatar of dankyle67
dankyle67

ASKER

Is there a way to check what version or mode of SQL server mgmt studio I am running? It is installed on SQL server 2008 server itself and I was actually able to edit plan by right clicking on design window of maintenance plan name but wanted to know if this is only way or correct way to edit or modify plan
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account