As backups are geo-redundant by default for SQL Database and SQL Managed Instance, you can easily restore databases to a different geographical region, which is especially useful for less strict disaster recovery scenarios. Backup storage is billed apart from regular dat...
SQL Server scenarios using the availability features High availability Disaster recovery Migrations and upgrades Show 6 more Applies to: SQL ServerThis article provides an overview of business continuity solutions for high availability and disaster recovery in SQL Server, on Windows and Linux.One...
If a database needs to be re-initialized due to reasons such as fault recovery, you can execute gs_initdb to initialize the database. Scenarios Although gs_initdb will try to create corresponding data directory, it may do not have the permission to do so. The reason is that the parent ...
Recovery ScenariosThe following scenarios describe various ways to invoke media recovery. Recovering a Closed DatabaseAfter the database is mounted, but closed, start closed database recovery (complete or incomplete) using either Enterprise Manager's Apply Recovery Archives dialog box, or the RECOVER ...
Chapter 18, "Performing Flashback and Database Point-in-Time Recovery"explains how to recover some but not all database changes.Chapter 30, "Performing User-Managed Recovery: Advanced Scenarios"explains how to respond when some but not all current control files or members of an online redo log...
🖥️Single Unified:A single system can support real-time data serving, interactive data analysis and offline data processing scenarios. ⚛️Federated Querying:Supports federated querying of data lakes such as Hive, Iceberg, Hudi, and databases such as MySQL and Elasticsearch. ...
For more information about how to modify the backup source, backup objects, or backup policy such as the backup time and backup set retention time of a backup schedule, see Manage a backup plan. For more information about backup and restoration scenarios, such as backup to the cloud, geo-...
You can move system or user-defined data and log files by specifying the new location in FILENAME. This may be useful in the following scenarios: Failure recovery. For example, the database is in suspect mode or shutdown caused by hardware failure. ...
The Only Check Offline Instance feature applies to the following scenarios: 1) The operating system of the server where the client is installed is reinstalled. 2) The client process and configuration are deleted by a malicious program. In such scenarios, the installed client cannot establish a co...
There are two scenarios for failover: planned and unplanned. A planned failover occurs when you schedule time to remove a server from operation maintenance or other reasons. An unplanned failover occurs when a server encounters a failure. In a planned failover: You use the Cluster service to...