DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: generate database maintenence plan script

  1. #1
    Join Date
    Apr 2004
    Posts
    5

    generate database maintenence plan script

    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?

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Apr 2004
    Posts
    5
    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?

Similar Threads

  1. Replies: 0
    Last Post: 08-23-2006, 12:21 AM
  2. Replies: 0
    Last Post: 08-23-2006, 12:19 AM
  3. Script Engine with Database
    By Tom in forum Mobile
    Replies: 0
    Last Post: 11-15-2001, 10:24 PM
  4. How to analyze corrupted Access databases
    By Raffaele in forum VB Classic
    Replies: 15
    Last Post: 06-27-2001, 09:28 AM
  5. Dynamic Update of DAO Using Model Database
    By Larry Rebich in forum vb.announcements
    Replies: 0
    Last Post: 08-26-2000, 12:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center