X hits on this document

536 views

0 shares

0 downloads

0 comments

167 / 200

Other applications of NetBackup for SQL Server Using NetBackup to restore SQL Server from Backup Exec images

12 When the other filegroups are restored, select the transaction logs.

13 On the Microsoft SQL Server tab, for the recovery completion state, choose Leave database operational and restore all of the transaction logs.

14 Optionally, you can also choose Point in time log restore or Restore log up to named transaction.

15 Click Start Restore.

Restoring the SQL master database from a Backup Exec image

If the master database is damaged, symptoms may include:

  • An inability to start SQL.

  • Segmentation faults or input/output errors.

  • A report generated by SQL Database Consistency Checker utility (DBCC).

If you can still start SQL, you can restore the latest copy of the master database backup using the Automate master database restore option on the Microsoft SQL Server tab and then restore any other databases, if needed.

If the master database is critically damaged and SQL cannot be started, rather than running the Rebuild Master utility or reinstalling SQL to be able to restart SQL, you can replace the corrupted or missing databases with the copies of the master and model databases that Backup Exec automatically creates and updates whenever backups of those databases are run. After SQL is running again, you can restore the latest copy of the master database using the Automate

167

Document info
Document views536
Page views536
Page last viewedFri Dec 09 20:45:31 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments