X hits on this document

482 views

0 shares

0 downloads

0 comments

93 / 200

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

7 8 9

Indicate a file name and click Save. In the Save Script As dialog box, click Yes to open the template in Notepad.

Change the database name in the template to the name of the database to restore to.

For example, replace:

  • #

    Replace the database name in

you

  • #

    want to move to. Also

remove

the

following

line with

the name

of the database

the

hash mark

<#> which

precedes

the keyword

that

<DATABASE>. #

  • #

    DATABASE "DatabaseA"

with:

  • #

    Replace the database name in

you

  • #

    want to move to. Also

<DATABASE>. # DATABASE "DatabaseB"

remove

the

following

line with

the name

of the database

the

hash mark

<#> which

precedes

the keyword

that

10 Change the path for the database files that you would like to restore. You must uncomment at least one file. For example, replace:

  • #

    Replace the file path <C:\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\DBA_FG1_File1.ndf>

    • #

      with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.

    • #

      The target of the MOVE keyword must be "DBA_FG1_File1".

MOVE #TO

" D " B A _ F G 1 _ F i l e 1 " C : \ M i c r o s o f t S Q L S e r v e r \ M S S Q L . 3 \ M S S Q L \ D A T A \ D B A _ F G 1 _ F i l e 1 . n d f "

with:

  • #

    Replace the file path <C:\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\DBA_FG1_File1.ndf>

    • #

      with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.

    • #

      The target of the MOVE keyword must be "DBA_FG1_File1".

MOVE TO

"DBA_FG1_File1" " C : \ M i c r o s o f t S Q L S e r v e r \ M S S Q L . 3 \ M S S Q L \ D A T A \ D B B _ F G 1 _ F i l e 1 . n d f "

11

Change the database file path. For example, replace:

  • #

    Replace the file path <C:\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\DatabaseA.mdf>

    • #

      with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.

    • #

      The target of the MOVE keyword must be "DatabaseA".

MOVE #TO

DatabaseA "C:\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\DatabaseA.mdf" " "

with:

  • #

    Replace the file path <C:\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\DatabaseA.mdf>

    • #

      with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.

    • #

      The target of the MOVE keyword must be "DatabaseA".

MOVE TO

"DatabaseA" "C:\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\DatabaseB.mdf"

93

Document info
Document views482
Page views482
Page last viewedWed Dec 07 00:20:35 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments