Post reply

One backup job - two copies

  • September 18, 2003 at 4:27 pm

    #162548

    Does anyone know if there is a way to run one DB backup that makes two copies of the bak file? We want to do this for both full and differential backups.

    We use xp_sqlmaint sp with a command like the following:

    EXECUTE master.dbo.xp_sqlmaint N'-D ben -Rpt "H:\mssql\backuplog\ben_Log_Report.txt" -DelTxtRpt 4WEEKS -WriteHistory

    -VrfyBackup -BkUpMedia DISK -BkUpLog "H:\mssql\backup" -DelBkUps 1WEEKS -BkExt "TRN"'

    But if there is a different method to make two copies other than xp_sqlmaint, I'm open.

    Thanks,

    Ben

  • September 18, 2003 at 5:06 pm

    #474955

    Well I don't use a maintenance plan for anything so I would do the following.

    STEP 1 (transact sql script)

    BACKUP DATABASE <DBName> TO <device name>

    ....

    STEP 2 (operating system command)

    COPY <filename> <newfilename>

    I have a separate step for each type of back up and copy so that I can fail the job and report it on each step.

    Gary Johnson

    Microsoft Natural Language Group

    DBA, Sr. DB Engineer




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

  • September 18, 2003 at 8:00 pm

    #474969

    good idea. Thank you.

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

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