Scheduled Backup and Restore to a different server

  • Hi all, I was after some free advice.

    I'm fairly new to SQL and have been tasked to solve a little problem.

    I need to backup a database from our LIVE server and restore to our DEV server on a weekly basis. Both servers are SQL2005.

    We have Backup Exec 2010 which performs a daily full SQL database backup and frequent log backups, it must take place before this on a Saturday.

    Can anyone give me some suggestions on the best way to do this?

    Kind Regards,

    Andy

  • I have scripted the backup and restore from one server to another. We use native SQL for the backup and for the restore. I restore from a file on the disk on one server to a different server and this is done on a nightly basis - immediately following the backup of said database.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Any chance you can send me a copy of the SQL code that you run so I can have a crack at tweaking it to fit our needs?

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

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