X hits on this document

419 views

0 shares

0 downloads

0 comments

94 / 200

To perform a partial database restore

1

Browse for the backup images you wish to restore. See “Browsing for backup images” on page 80.

2

In the Restore Microsoft SQL Server Objects dialog box, expand the desired instance.

3 4 5

Expand the database. Select the database image that you want to restore. From the Scripting list, select Create a partial database restore template.

Note: When you are preparing your database design, map logically related database components such as tables, indexes, keys, etc., to the same filegroup. This will enable you to use the partial database restore procedure, which follows, to recover these logically related components as a single unit.

12 Make similar changes to the template for any differential or transaction log backups you wish to move.

13 When you are finished modifying the template, save it.

14 To run the restore, choose File > Manage script files, select the script you created, and choose Start.

15 Click Yes to launch the restore. To view the progress of the restore, choose File > View status.

Performing partial database restores (SQL Server 2000)

The following instructions show you how to perform a partial database restore on a SQL Server 2000 database. A partial database restore lets you select individual filegroup components of a database and restore them to a new database having a different name.

94

Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface

Document info
Document views419
Page views419
Page last viewedSun Dec 04 06:33:32 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments