• artbalauro (11/17/2014)


    Hi there,

    Just want to ask if theres a way on sql management studio 2005, to create one job for one database having steps and scheds ( daily, weekly, monthly ) to do backup to my database.

    My Steps consist of commands where to store my backup files ( ex. step 1 for database 1 to be save on daily folder that i created, step 2 on d:/____/_____/weekly/week1/database1_kbp/, step 3 d:/____/____/weekly/week2/database1_bkp/ and so on

    please help thanks,

    Just a suggestion... you're busting up you backups by week and that's going to be really difficult to manage especially when it comes to deleting old backups. My recommendation would be to name the files using the database name and the date/time of the start of the backup and have ALL the backups for a given database in a single directory.

    As for doing the actual backups, I use stored procedures that figure out what needs to be done for my particular instances and the databases on a given instance. My backup job for full backups has just one line in it... EXEC DBA.util.FullBackups.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)