Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Where To Create/Modify Database Maintenance Plans Expand / Collapse
Author
Message
Posted Thursday, July 16, 2009 9:52 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:43 AM
Points: 442, Visits: 620
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
Posted Friday, July 17, 2009 12:59 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 12, 2013 1:15 AM
Points: 187, Visits: 376
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
Posted Friday, July 17, 2009 9:40 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:43 AM
Points: 442, Visits: 620
Hi Raj

thanks for your input

Jim
Post #754942
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse