X hits on this document

534 views

0 shares

0 downloads

0 comments

159 / 200

Restore all database files to the target instance’s data

Select this checkbox to restore files to the default data and log directories of the destination instance. For example, if you are restoring a database to a different

location

instance of SQL, you would select this option to move the database files to the

correct location for the new instance.

159

Table 9-14

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

Restore options on the Microsoft SQL Server tab (continued)

Note: Do not select the Restore all database files to the target instance’s data location option when restoring filegroups. Filegroups must be restored to the same drive letter and path that they were backed up from.

Only when original drive does not exist

Select this option to restore all database files to their original directory path on the alternate drive, only if the drive where they originally resided exists. To make this option available, select a drive letter in Alternate drive for restoring database files list.

Even when original drive does exist

Select this option to restore all database files to their original directory path on the alternate drive, even if the drive where they originally resided exists. To make this option available, select a drive letter in Alternate drive for restoring database files list.

Restore log up to named transaction (SQL 2000)

Select this checkbox to restore transactions from a transaction log up to a named transaction (or named mark) in the transaction log; after that, recovery from the transaction log is stopped. The named transactions are case-sensitive.

Include the named transaction

Select this checkbox to include the named transaction in the restore; otherwise the restore will stop immediately before the named transaction is restored.

Found after

Select this checkbox to specify a date and time after which the restore operation is to search for the named transaction. For example, if you specify a restore from a log up to the named transaction AfternoonBreak, found after 6/02/2003, 12:01 p.m., then the restore operation will not search for AfternoonBreak until after that time.

If this option is not selected, then the files are restored to the directory that the master database is in.

Point in time log restore

Select this checkbox to restore transactions from a transaction log up to and including a point in time in the transaction log. After the point in time, recovery from the transaction log is stopped.

Select the part of the date you want to change, and then enter a new date or click the arrow to display a calendar from which you can select a date.

Select the part of the time you want to change, and then enter a new time or click the arrows to select a new time.

Item

Restore to alternate drive

Description

Document info
Document views534
Page views534
Page last viewedFri Dec 09 18:51:12 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments