Die Funktion zum Senden von Formularen auf der Support-Website ist aufgrund planmäßiger Wartungsarbeiten vorübergehend nicht verfügbar. Wenn Sie sofort Unterstützung benötigen, wenden Sie sich an den technischen Support. Wir bitten, jegliche Unannehmlichkeiten zu entschuldigen.
Konnten Sie mithilfe dieses Artikels ein Problem lösen?
Bewertung auswählen
Titel
Restoring SQL Databases
Beschreibung
You need to recover a SQL database or table from a recovery point.
Click here for a step by step instructional video of this process.
Lösung
Complete the following steps.
Launch the Core Console.
Click on the agent machine and go to the Recovery Points tab.
Expand the desired recovery point from which you wish to restore by clicking the arrow beside it.
Click Mount.
In the Mount dialog box, specify the path to mount this recovery point. This will be the location to access the data in Windows Explorer.
In the Mount dialog box, specify which volumes to mount. You must choose at least one volume. If you have multiple volumes you can mount all volumes at the same time.
In the Mount dialog box, choose Writable.
In the Mount dialog box, if you would like to mount the recovery point as a network share you can do this as well. Check ‘Create a Windows share for this Mount’ checkbox, then enter the share name and specify which users/groups have access (optional).
After the required fields have been filled in the Mount dialog box, click Mount.
The Recovery Points tab will automatically return until the mount begins, at which time a ‘Monitor Task’ window will display to view the progress of the mounting job.
Users can also view mounting progress from the events tab.
Once the mount is completed, open windows explorer and navigate to the mount path that was specified in Step 4.
You can also locate all current mounts from Core>Tools>Mounts. This displays all mounted recovery points in the system at the given time and the location where they are mounted to.
Use the SQL Server Management Studio application to attach the database, and then copy over any desired data.
To attach the database:
Open and log into the SQL Server Management Studio application.
Attach the database by pointing to the mounted recovery point volume(s). **Note: SQL Version must be same edition as source or higher. ie: Standard edition cannot open Enterprise SQL database.
If the logs are in another location other than the same as the databases, make sure to correct the “Attach dialog” path to the correct location for the respective log files.
After the database is attached, use any of the typical SQL tools to retrieve the data.
After mounting and attaching the database, do one of the following:
Copy the table or rows back to the original database by using either INSERT, BCP (Bulk Copy Utility), or SELECT INTO.
Right-click on the original database name, select Tasks, and then click Import Data.
Point to the attached database or recovery point on the Core.
Once data has been recovered, it is a good idea to dismount the recovery point. This can be accomplished from the Core>Tools>Mounts page by clicking ‘Dismount’ on the mounted recovery point.
Note: stopping the Core Service will dismount all active mounted recovery points.
For more information on various SQL commands, click here.
Weitere Informationen
Note: Steps 7-10 are not done within the Rapid Recovery software. They are done in the Microsoft applications Windows and SQL Server.
Feedback übermittelt
Konnten Sie mithilfe dieses Artikels ein Problem lösen?
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Empfohlener Inhalt
Produkt(e):
Rapid Recovery
6.6, 6.5, 6.4, 6.3, 6.2.1
Thema/Themen:
How To
Artikelhistorie:
Erstellt am: 1/27/2014 Letzte Aktualisierung am: 6/28/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Willkommen beim Support!
Online-Support-Hilfe für Quest *Produkt* finden Sie auf einer zugehörigen Support-Seite. Klicken Sie auf "Weiter", um zum entsprechenden Support-Inhalt und zur entsprechenden Unterstützung für *Produkt* weitergeleitet zu werden.
Alle Artikel durchsuchen
Die Internet Explorer Versionen 8, 9 und 10 werden nicht mehr unterstützt.
Die Internet Explorer Versionen 8, 9 und 10 werden vom Quest Software Portal nicht mehr unterstützt. Wir empfehlen Ihnen, Ihren Browser auf die neueste Version von Internet Explorer oder Chrome zu aktualisieren.
Zum Upgraden auf Internet Explorer 11 hier klicken