- Notes, cautions, and warnings
- Preface
- Overview
- Configuration
- Configuring NMM in a SQL VDI environment
- Supported Windows Server and SQL Server versions
- Migrating from VSS solution to VDI solution for SQL Server data protection
- Multi-stream Data Domain Boost
- Microsoft SQL Server Always On Availability Group feature
- Availability group listeners
- Clusterless availability group listeners
- SQL Client Direct to AFTD or DD devices
- Microsoft SQL Server named log marks
- Database consistency checks
- Microsoft hybrid cloud environments
- Transparent data encryption
- Setting the MAXTRANSFERSIZE environment variable
- Configuring permissions to perform NMM backup and recovery of Microsoft SQL Server
- Configuring NMM in a SQL VDI environment
- Graphical User Interfaces
- Manual Backups
- Scheduled Backups
- Overview of scheduled backup
- Prerequisites
- Federated backup preferences for Availability Group databases
- Excluding incompatible databases in backups
- Configuring scheduled backups
- Setting up backup levels
- Configuring a client resource
- Setting data protection policies
- Monitoring scheduled backups
- Data Restore
- Granular Level Recovery
- Striped Backup and Recovery
- Disaster Recovery
- Bare Metal Recovery
- Troubleshooting
Dell EMC NetWorker Module for Microsoft for SQL VDI 19.7 User Guide
Recovery modes
To recover a database, you must specify a recovery mode. A recovery mode instructs the SQL Server how to interact with the database after the recovery operation completes. For instance, recovery modes can leave the database in an intermediate state, so additional transaction logs can be applied.
The following table shows how the recovery modes correspond to SQL Server database restore options.
| Types of recovery mode | Description |
|---|---|
| Normal | The normal restore mode instructs SQL Server to leave the database in an operational state after the restore completes. This state then enables database reads and writes. The normal restore mode is the default mode NMM uses when restoring a database. |
| No-recovery | The no-recovery restore mode activates the SQL Server NORECOVERY database restore option for the last stage that was restored. The no-recovery restore mode places the database in a state that cannot be loaded after the restore, but it is still able to process additional transaction log restore operations. |
| Standby | The standby restore mode activates the SQL Server STANDBY database restore option for the last stage that is restored, which forces the database to be in a read-only state between transaction log restore operations. The standby restore mode provides an undo file for SQL Server to use when rolling back the transactions. |
| Online | SQL Server provides the ability to perform a restore operation while a SQL Server database is active. The database is completely offline only while the primary file group is being restored. After the primary file group is restored, the database can be brought online while the rest of the file groups are being restored, and then only the data that is being restored is unavailable. The rest of the database remains available during this type of restore. Earlier versions of SQL Server require that you bring a database offline before you restore the database. |
Veuillez attribuer une note (1 à 5 étoiles).
Veuillez attribuer une note (1 à 5 étoiles).
Veuillez attribuer une note (1 à 5 étoiles).
Veuillez indiquer si l’article a été utile ou non.
Les commentaires ne doivent pas contenir les caractères spéciaux : <>()\