How to Mount SQL Databases

This section provides information about mounting the Microsoft SQL databases.

Follow these steps:

1. Open the Arcserve UDP Agent UI that is hosted on the Database Server.
2. From the Tasks pane, click Mount SQL Database.
3. 
4. The Mount SQL Database dialog appears and displays the list of mounted databases.
3. To update the backup destination and Recovery Point Server, click Change.
4. 
5. The Source dialog appears.
4. On the Source dialog, select one of the following backup locations, and then click OK:
5. 
6. Select local disk or shared folder
1. Specify or browse to the location where you stored the backup images, and then select the appropriate backup source.
2. To verify the connection to the specified location, click the green arrow button. If required, enter the Username and Password to access to that source location.
3. The Select backup location dialog opens.
3. Select the folder in which you stored the recovery points, and then click OK.
4. The Select backup location dialog closes and you can see the backup location in the Source dialog.
5. The recovery points are listed in the Browse Recovery Points dialog.
7. Select Recovery Point Server
1. Specify the Recovery Point Server setting details, and then click Refresh.
2. All the agents are listed in the Data Protection Agent column in the Source dialog.
2. Select the agent from the displayed list.
3. The recovery points are listed in the Browse Recovery Points dialog.
4. Note: If the recovery point you are attempting to mount is encrypted, Arcserve UDP Agent dialog opens and prompts you to enter the session password.
5. To provide the session password, do the following:
1. On the Arcserve UDP Agent dialog, click the Import button.
2. 
3. The Import session password dialog appears.
2. Specify or browse to the location where the session passwords file is located, enter the encryption key if needed, and then click OK.
3. 
3. On successful import, the session password gets auto filled in the Password field.
6. Note: If a clock icon appears with a lock symbol, it indicates that the recovery point contains encrypted information and may require a password for restore.
5. From the Recovery Point Date section, select a date.
6. The corresponding recovery points for that date are displayed, with the time of backup, the type of backup that was performed (Full, Incremental, or Verify), and the name of backup.
6. Expand SqlServerWriter, <destination host>, <database instance>, and then click Mount next to the database that you want to mount.
7. Notes:
• If the recovery point that you have selected is SQLServerWriter backed up, then you can navigate to instances and databases.
• The Mount option appears only for the user databases.
8. 
9. The Mount SQL Database dialog appears.
7. On the Mount SQL Database dialog, do the following, and then click OK:
1. From the Mount Database to Destination Instance drop-down list, select the destination instance as needed.
2. Note: If a database is FileStream enabled, the Mount Database to Destination Instance drop-down lists only the FileStream enabled instances. However, if the database is not FileStream enabled, the Mount Database to Destination Instance drop-down displays both the FileStream enabled and disabled instances.
2. For New Mount Database Name, specify a unique name for the new database. By default, the database name is ArcserveMount_<selected db name>. You can append a name to the default prefix (ArcserveMount_) or give a completely new name.
3. Note: The new database name must be unique and can be a maximum of 128 characters.
3. To perform the Point-In-Time (PIT) restore, do the following:
1. Under Advanced Setting, select the Mount to a point in time check box, set the time point using the slider or manually set the desired time.
2. Notes:
• You can enable the Point-In-Time (PIT) option only when the N and N+1 backup sessions have PIT enabled.
• The Mount to a point in time check box gets enabled only when the destination instance is same as source instance.
2. (Optional) To view transaction details, click the Click here hyperlink.
3. The Transaction Details dialog appears and displays the list of transactions based on the date and time selected.
3. To configure the transactions listed at a database level, click the Select this event button.
4. 
5. Note: To view the transactions performed between N and (N+1) recovery points, use the Previous and Next buttons.
8. To unmount the SQL database after a specified time, from the Unmount the SQL Database After drop-down list, select the unmount time as needed. The available options are 4 Hours, 10 Hours, 24 Hours, and 1 Week.
9. The SQL database gets automatically unmounted after a specified time.
10. 
11. After successful mounting, the database gets listed under the List of Mounted Database table with an Unmount option.
9. To unmount the mounted SQL database manually, click the Unmount option corresponding to the SQL database that you want to unmount.
10. 
11. Note: When you delete the mounted database from the SQL Server Management Studio, it will get unmounted from the Agent UI after you refresh the page.
10. Click Close.
11. The Microsoft SQL database is mounted successfully.

Note: For limitations of mounting the Microsoft SQL database, see Microsoft SQL Server Related.