Post reply

Automate Restore 2005 sql using maintenance plan

  • May 8, 2008 at 7:45 am

    #207129

    sql 2005, using mangement studio -

    database and transaction files are being backed up to another server.

    Do anyone know how to create a maintenace plan that allows me to create a daily job that will restore my database with a most newest database .bak, and restore the transaction log from specific point in time fram?

  • May 8, 2008 at 9:11 am

    #812472

    A maintenance plan won't do this. It doesn't really have the tasks, though I guess you could use the Execute SQL tasks Execute Agent Job

    You'd have to write a script that can check the files to see where the most recent BAK is. I guess you could RESTORE FILELIST ONLY to get the data from the backup and then make a decision about which file to restore.

    To do the logs, you need to do the same thing, but really check the dates/times to determine what to restore.

    Why not just use log shipping?

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

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