08-31-2012 10:52 AM
I have Backup Exec 2012 and I need restore a data base in MS Sql 2008 and add of transactions log.
How leave database nonoperational to restore additional transaction logs?
Thanks.
Solved! Go to Solution.
08-31-2012 07:57 PM
When running the restore wizard, you will encounter this screen.
Specifies the backup sets that you want to use to restore the database. Include the full backup, differential backups, and log backup sets.
If you restore multiple backup sets, select the Leave the database nonoperational; additional transaction logs or differential backups can be restored option in the Restore Wizard for each backup set except the last one. For the last backup set, select the Leave the database ready to use; additional transaction logs or differential backups cannot be restored option in the Restore Wizard.
08-31-2012 07:57 PM
When running the restore wizard, you will encounter this screen.
Specifies the backup sets that you want to use to restore the database. Include the full backup, differential backups, and log backup sets.
If you restore multiple backup sets, select the Leave the database nonoperational; additional transaction logs or differential backups can be restored option in the Restore Wizard for each backup set except the last one. For the last backup set, select the Leave the database ready to use; additional transaction logs or differential backups cannot be restored option in the Restore Wizard.
09-04-2012 11:05 AM
Thank you, it was useful. But I now have another problem when selection a backup set with this option tells me:
Updating restore job.....
Unable update the sqlserver restore 000xx.
The restore job has no seleccionts.