NetBackup™ for Microsoft SQL Server Administrator's Guide

To perform a database move

1. Open the NetBackup MS SQL Client.
2. Browse for the backup images you want to restore.

3. Expand the database instance.
4. Select the database backup image that you want to restore.
5. From the Scripting list, select Create a move template.

   When you create a move script, the capability to perform an immediate launch is disabled. You must edit the script to specify certain destination parameters.

6. Click Restore.
7. Indicate a file name and click Save > Yes.
8. Change the database name in the template to the name of the database to restore to.

   For example, replace:

   #  Replace the database name in the following line with the name of the database that you 
   #  want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
   # 
   # DATABASE "DatabaseA"

   with:

   #  Replace the database name in the following line with the name of the database that you 
   #  want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
   # 
   DATABASE "DatabaseB"

9. Change the path for the database files that you want 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  "DBA_FG1_File1"
   #TO  "C:\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\DBA_FG1_File1.ndf"

   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  "DBA_FG1_File1"
   TO  "C:\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\DBB_FG1_File1.ndf"

10. 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  "DatabaseA"
    #TO  "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  "DatabaseA"
    TO  "C:\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\DatabaseB.mdf"

11. Make similar changes to the template for any differential backups or transaction log backups you want to move.
12. When you finish modifying the template, save it.
13. To run the restore, select File > Manage script files.
14. Select the script that you created and click Start > Yes.