Search code examples
sql-serversql-server-2012database-backupsdatabase-restore

Auto restore SQL Server database backup for test

I use SQL Server 2012 and create maintenance plan to create full backup each day. I want to create restore test backup end of each week from last created full backup. if this restore failed alert me by email and if restore complete successfully delete restored database.

EDIT :

1- I want to use maintenance plan to restore database

2- I want to find last full backup

what shall I do.

thanks in advance

Solution

  • I use 'Red Gate Backup Pro 7` to create and restore backup.

    Red Gate Backup pro restore last exists backup automatically by set full backup, Diff backup and Trn Backup folders.