Where To Create/Modify Database Maintenance Plans

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » Where To Create/Modify Database Maintenance...

Where To Create/Modify Database Maintenance Plans

Rate Topic

Display Mode

Topic Options

Author

Message

JC-3113

Posted Thursday, July 16, 2009 9:52 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:44 PM
Points: 442, Visits: 619

Hi Folks

I have a question on just where the Maint Plans should be created and modified.

Should it be SSIS or should it be SSMS or does it matter ?

Thanks

Jim

Post #754309

raj acharya

Posted Friday, July 17, 2009 12:59 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 17, 2012 7:07 AM
Points: 186, Visits: 343

hi,

you can do that through both ...
but for easy way go to management studio and into that go management
there you will see maintenance plan .... and create new ...

through ssis also you can perform this tasks of maintenance plan....

Raj Acharya

Post #754650

JC-3113

Posted Friday, July 17, 2009 9:40 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:44 PM
Points: 442, Visits: 619

Hi Raj

thanks for your input

Jim

Post #754942

« Prev Topic | Next Topic »

Permissions