Post reply

backup file name generated by maintenance plan wizard is too large

  • August 25, 2010 at 7:27 am

    #387656

    HI

    We use maintenance plan wizard with SQL server 2008 to create maintenance plans.

    Is it possible to eliminate the sequence numbers ("_6540685") that are appened automaticaly at the end of the backup file name (TYPE=DISK)

    exemple

    Very_long_DB_name_backup_2010_08_20_094506_6540685.trn

    Very_long_DB_name_backup_2010_08_20_094506.trn ("_6540685" is not there)

    I ask this question because ==> some others tools fail because the backup file name is too large

    Is it possible ?

    If not, what is the purpose of the sequence numbers appened automaticaly at the end of the backup file name ?

    thank you

    calico

  • August 25, 2010 at 1:28 pm

    #1211874

    I am not sure if we can control the file naming convention in Maintenance Plans. If you want to change the naming conventions, use custom scripts. Some good examples are here[/url]

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • August 25, 2010 at 1:44 pm

    #1211888

    Maintenance plans are good...to a point. I highly suggest checking out Brad McGehee's book on Maintenance Plans (free download): http://www.bradmcgehee.com/2010/01/free-ebook-on-sql-server-maintenance-plans-now-available/[/url]

    While the GUI is nice, you can still do what you need via code. By utilizing T-SQL you can customize plans more to your taste/needs.

    =============================================================
    /* Backups are worthless, Restores are priceless */

    Get your learn on at SQL University!
    Follow me on Twitter | Connect on LinkedIn
    My blog: http://sqlchicken.com
    My book: Pro Server 2008 Policy-Based Management

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply