Member Avatar for sguy

hi,
after I manually create maintenance plan using SQL server Maintenence Plan Wizard with SQL Server Management Studio 2005, is there any way to create a script for all these setting that I've done?
So that I can just modify the database name and run it on another pc,
the same setting will apply in this pc. Or is there other ways to do
it?

  • 1 Contributor
  • 1 Reply
  • 63 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by sguy
Member Avatar for sguy

when i try to right click the Database Maintenance plan that i've created, i can't see Export function.
I also can't find the phisical file in any folder, can i use SSIS to export it? where can i find the physical file that created by me?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.