SQL Server Performance

Maintenance Plans questions

Discussion in 'SQL Server 2005 General DBA Questions' started by sonnysingh, May 22, 2007.

  1. sonnysingh Member

    Hi folks

    I am looking for how to create Full Backup and Transactional Backup through one Maintenance Plan on separate time and folder. Also remove few days or (whatever time) older backups exactly you can do it using SQL Server 2000. I could not find this options in SQL server 2005's Maintenance Plan.

    Secondly..generating objects scripts as separate file when you choose more than one objects in one go as there is option for one file only rather separate fils (PRC,UDF extension files so on...) similiarily in SQL server 2000.

    Thanks in Advance
    sonny
    sonnysingh, May 22, 2007
    #2

  2. sonnysingh Member

    please remove or disable this thread.. as I have added it twice cos of internet error...
    sonnysingh, May 22, 2007
    #2

  3. MohammedU New Member

    Locked...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
    MohammedU, May 22, 2007
    #2

Share This Page