X hits on this document

499 views

0 shares

0 downloads

0 comments

97 / 200

A tail-log backup and recovery operation, which is required in order to bring the database on-line.

Requirements and limitations

Pages can be restored from the following backup types: database, filegroup, file, read-write filegroups, partial database.

Your SQL Server 2005 database must use either the full or bulk-logged recovery model in order for page-level restore to be available to you.

SQL Server sometimes cannot recover the specific pages that you request if they contain critical information about the definition of the database itself. For example, you cannot use page-level restore for the first page in a database file. When you detect that page-level restore will not work, then you will need to resort to using full database recovery.

A maximum of 1000 pages can be recovered from a backup image through a page-level restore.

To perform a page-level restore

1

Obtain a list of corrupt pages in the database.

SQL Server 2005 Books Online suggests several methods for obtaining a list of corrupt pages. One of these methods is to run the command DBCC checkdb from the SQL Server 2005 Management Studio.

2

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

3

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

4 5

Expand the database.

Select the database backup image that contains pages that you want to restore.

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

97

Document info
Document views499
Page views499
Page last viewedThu Dec 08 04:20:41 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments