Restore SQL Server with Arcserve UDP
Arcserve UDP is an advanced backup and replication product developed for data centers where virtual and physical servers are located together, incorporating “Arcserve Backup”, “Arcserve d2d” and “Arcserve rha” software. With Arcserve UDP, backup and restore operations of physical and virtual servers can be performed on an image basis without an agent or using an agent. It has recently attracted attention with many features that distinguish it from its competitors in server backup.
In our article, we will talk in detail about how to perform Microsoft SQL Server Restore with Arcserve UDP. The diagram below shows the steps to be followed in order.
Before performing a Microsoft SQL Server restore operation with Arcserve UDP, make sure that the following prerequisites are met;
- Before performing the SQL Server Restore operation, you must have a running instance of the Microsoft SQL Server database.
- Check the compatibility of the operating system, database, and internet browser with Arcserve UDP.
Warnings;
- The “Restore to alternative location” option that you will see during the restore process with Arcserve UDP means that you can change the name and file location of the database.
- With Arcserve UDP, multiple restore operations can be performed simultaneously for different virtual machines. However, it only allows a single restore operation on the same virtual machine.
- On Windows, only one restore operation can be performed at a time. If you try to start another operation while the restore is in progress, you will encounter a warning that another restore operation is being performed and that you should try again later.
To perform a SQL Server Restore operation with Arcserve UDP, we first log in to Arcserve UDP and select the "Restore" section under the "Tasks" tab on the home page.
Then, in the window that opens, we select the "Browse Recovery Points" section.
From the "Backup Location" section, we select the location where the SQL Server backups to be restored are located. Then you will see the list of SQL Server backups that can be restored. From here, we select the database we want to restore and proceed.
After proceeding, 3 different options will appear on the screen.
Restore to Original Location: It will restore to the location where the backup was taken, that is, to the location of the original file.
Dump File Only: Only restores dump files. Dump files are created with timestamp information in order to fix the problem later when the software crashes due to an error. It actually acts as a log. When this option is selected, any location can be selected and the restore operation can be done to the desired location.
Restore to Alternate Location: Arcserve is the most commonly used option for SQL Server restore with UDP. It allows the restore process to be performed to a location of your choice other than the original location. The desired database is selected from the list and the restore process can be performed with a new location and a new database name.
We click on the “New Database Name” field and specify a new name, and then we specify the location where the restore process will be performed with the Browse option.
We proceed with “Next” one last time and ensure that the restoration process begins. After that, we wait for the process to finish in proportion to the size of the backup file. We can follow the process from the Job Monitor section on the homepage.
After the restore process is complete, we recommend that the verification process in the last step of the diagram we mentioned at the beginning of the article be performed. The verification process is to check whether the files are present in the relevant location after the SQL Server restore process with Arcserve UDP and whether the relevant database is located in the Microsft SQL Server Management Studio. In the screenshot below, we see our database with the new name we specified in SQL Server Management Studio. The restore process has been completed successfully.
