The recovery progress is shown on the Activities tab. This value is primarily used to detect the point in time when a SQL Server error occurred. However, it will save the undo actions in a temporary standby file so that the recovery effects can be reverted. The software will undo any uncommitted transactions. You will be able to recover additional transaction logs from the native Microsoft SQL backups and thus reach the necessary recovery point.Īfter the recovery completes, users will have read-only access to the database. The software will keep all uncommitted transactions of the recovered database. Non-operational (RESTORE WITH NORECOVERY)Īfter the recovery completes, the database will be non-operational.You will not be able to recover additional transaction logs from the native Microsoft SQL backups. The software will roll back all uncommitted transactions of the recovered database that are stored in the transaction logs. Ready to use (RESTORE WITH RECOVERY) (default)Īfter the recovery completes, the database will be ready for use.To change the database state after recovery, click the database name, and then choose one of the following states:.The folder you specify must not contain the original database and log files. Specify the new database path and log path.To recover a database as a different one to the same instance: You can select another SQL Server instance (running on the same machine) to recover the databases to. If the original database does not exist, it will be recreated. By default, the databases are recovered to the original ones.If you want to recover the databases as files, click Recover as files, select a local or a network folder to save the files to, and then click Recover.Double-click an instance to view the databases it contains. Select the data that you want to recover.When recovering from an application-aware backup, click Recover > SQL databases.When recovering from a database backup, click Recover SQL databases.
The machine chosen for browsing in either of the above actions becomes a target machine for the SQL databases recovery. Select a recovery point on the Backups tab.other agents can access it), click Select machine, select an online machine that has Agent for SQL, and then select a recovery point. If the backup location is cloud or shared storage (i.e.If the original machine is offline, the recovery points are not displayed. Note that recovery points are filtered by location. Select the machine that originally contained the data that you want to recover.When recovering from a database backup, click Microsoft SQL.It's Evgeny from Acronis Service Providers Support.Īs far as I understand, you would like to know how to recover the SQL databases in a situation when the original machine is not available.
0 kommentar(er)
