KB labels


Ticket Product Version

Ticket Category

Ticket Assignee


Hot Fixes

Published Fixes
Your Arcserve Support User Profile
First Name:
Last Name:
email:
Phone:
Company:*
Customer Type:
Language:

Country:
Region:

Time zone:
Follow

arcserve-KB : How to Restore Microsoft SQL Server Database with arcserve D2D?

Last Update: 2016-11-23 17:16:31 UTC

CA ARCSERVE D2D: 15.0
Last Modified Date:    05/07/2010
Document ID:    TEC520437
Tech Document
Title:  How to Restore Microsoft SQL Server Database with CA ARCserve D2D?

Description:

This document explains about the steps to restore a Microsoft SQL Server Database using CA ARCserve D2D.

Solution:

  1. Login into CA ARCserve D2D and click on 'Restore' under 'Tasks' as shown below.

    Figure 1
  2. Now Click 'Browse Recovery Points'.

    Figure 2
  3. Now select the Recovery Point (Date and Time). From the bottom right pane of the restore dialog, expand the SqlServerWriter -> Server Name -> SQL Instance and then select the Microsoft SQL Server database which has to be restored. After making the selection, click the 'Next' button.

    Figure 3
  4. The restore options are,

    Restore to original Location
    Dump file only
    Restore to alternative location

    Note: Due to Microsoft restrictions, a SQL Server database cannot be restored to a compressed drive. As a result, the following limitations will affect CA ARCserve D2D attempt to restore a Microsoft SQL Server database to a compressed volume:

    • Restore to original location. This restore will fail if the original location for the restored database has been compressed.
    • Restore to alternate location. This restore will fail if the alternate destination location for the restored database has been compressed.
    • Dumping of Microsoft SQL Server database files to any location is not restricted by this limitation.
    1. Restore to Original Location:

      Specifies to restore to the original location from where the backup image was captured. Click on 'Next'.

      Note:- This would overwrite the original database.

      Figure 4

      In the next page verify the Restore Summary and click on 'Finish' to begin the restore process.
    2. Dump file only:

      Specifies to restore the dump files only. Dump files are created when an application crashes and contains additional (time-stamped) information that can be used to troubleshoot the cause of the problem.

      This would restore the Microsoft SQL Database mdf and ldf files to the dump location specified.

      Specify the path or browse to the folder location where the dump files needs to be restored. Once the destination path is specified, click 'Next'.

      Figure 5

      In the next page verify the Restore Summary and click on 'Finish' to begin the restore process. After the restore finishes, the files can be seen under the path specified.

      Figure 6
    3. Restore to alternate location:

      Specifies to restore to an alternate location (not the original location).

      When this option is selected, a listing of all the databases that was selected to restore is displayed, along with each instance that contains the selected databases.

      Multiple database restore can be performed (simultaneously) from the instance level. From this listing you can select the database instance and specify a new database name and alternate location to restore the database to. In addition, you can also browse to the alternate location where the database needs to be restored to.

      After making the changes, click on 'Next'.

      Figure 7

      In the next page verify the Restore Summary and click on 'Finish' to begin the restore process.
  5. The restore summary would be shown as below, the restore summary would vary based on the restore options and the components selected for the restore. Click on 'Finish' to begin the restore process.

    Figure 8
  6. The following informational message will be displayed once the restore job is submitted.

    Figure 9
  7. The progress of the restore job can be seen in the Job Monitor Panel in CA ARCserve D2D Home Page.

    Figure 10

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments