Post reply

DB backup and restore plan

  • July 9, 2009 at 12:04 am

    #72386

    In our company, we are using several servers, but two of those are the most used, the production server and the reports server. then we also have an external backup device in which we direct our full and differential backups.

    we want to implement a new plan for our regular backup and restore process.

    here goes:

    we want to backup our database from the production server which will be directed and restored to our report server, then we also want our external device to have a copy of our backup.

    I am thinking of automating the copying process of the backup file from the report server instead of the manual right click, copy, then paste to external drive.

    how can i automate copying of backup file from the report server to the external device? or is there any other way we can execute our backup/restore plan?

    Thank you,

    Isabel

  • July 9, 2009 at 1:48 am

    #1022195

    you can think of using xp_cmdshell in this case.

    Am guessing there must be a backup job. edit the job to add a new job step after backup which will copy the backups to different location using this command.


    Pradeep Singh

  • July 9, 2009 at 1:48 am

    #1022196

    Edit - duplicate post coz of site issue.


    Pradeep Singh

  • July 9, 2009 at 1:48 am

    #1022197

    Edit - Duplicate post coz of site issue


    Pradeep Singh

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

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