X hits on this document

483 views

0 shares

0 downloads

0 comments

96 / 200

96

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

#DATABASE "DatabaseA"

with:

  • #

    Replace the database name

you

  • #

    want as the target of the

precedes

in the following

line

with the name of the

database that

partial restore.

Also

remove the hash mark

<#> which

#

the

keyword

<DATABASE>.

DATABASE

"DatabaseB"

10 To restore a file, indicate a new file path and uncomment the MOVE and TO lines.

For example, replace:

  • #

    If you wish to restore file <C:\Program Files\Microsoft SQL

Server\MSSQL\data\Sample2.mdf>,

#

then

replace

this

path

with

a

new

file

path

. Also remove the hash marks <#>

  • #

    which precede the keywords <MOVE> and <TO>.

#MOVE #TO

"DBA_FG1_File1" "C:\Microsoft SQL

Server\MSSQL.3\MSSQL\DATA\DBA

_

FG1

_

File1.ndf"

with:

  • #

    If you wish to restore file <C:\Program Files\Microsoft SQL

Server\MSSQL\data\Sample2.mdf>,

#

then

replace

this

path

with

a

new

file

path

. Also remove the hash

marks

<#>

  • #

    which precede the keywords <MOVE> and <TO>.

MOVE TO

"DBA_FG1_File1" "C:\Microsoft SQL

Server\MSSQL.3\MSSQL\DATA\DBB

_

FG1

_

File1.ndf"

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

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

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

Performing page-level restores (SQL Server 2005)

If a portion of a SQL Server 2005 database has been corrupted due to hardware failure, you may be able to use page-level restore to recover only the pages that were corrupted. Page-level restore can reduce the total downtime, if you only need to restore a relatively small number of pages. If many pages are corrupt, then a full database recovery may be faster.

When you choose the page restore option, NetBackup for SQL Server creates a page restore template. This template includes the following parts:

  • A page restore operation that you will modify by inserting the IDs of the pages that you wish to restore.

  • A series of transaction log images, if available, for recovering the database to the current point in time.

Document info
Document views483
Page views483
Page last viewedWed Dec 07 08:43:26 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments