Database restoration RRS feed

  • Question

  • Hi Team,

    I need to do a copy of my prod db on to a another remote server ie.. I need to do backup and restore.
    Currently I am doing it manually and I would like to automate this process.
    So Can you provide me the steps and script to fix on this issue.

    I am currently doing the below steps,

    1) backup of prod server
    2) moving the backup files over the network
    3) restoring the remote db with replace option
    Thursday, August 30, 2012 2:08 AM