Back Up and Restore Replicated Databases - SQL Server
Sep 27, 2024 · Replicated databases require special attention with regards to backing up and restoring data. This topic provides introductory information and links to further information on …
Restore files (and filegroups) over existing - SQL Server
Feb 28, 2023 · This article shows you how to restore files and filegroups over existing files in SQL Server by using SQL Server Management Studio or Transact-SQL.
Prepare a Mirror Database for Mirroring (SQL Server)
Using RESTORE WITH NORECOVERY, create the mirror database by restoring the full database backup and, optionally, the most recent differential database backup, onto the mirror server …
Restore Azure SQL Managed Instance DB from One Server to …
Nov 26, 2023 · SQL Managed Instance databases can only be restored to SQL Server 2022 (either on-premises, or on a virtual machine) if the source SQL Managed Instance has enrolled …
How to Restore a SQL Database after the Server has been …
Oct 29, 2024 · If you need to restore an (unexpired) LTR database backup you may restore it to a different logical server. To do this you would first list the LTR backups using …
Recover database - no restore (Transact-SQL) - SQL Server
Aug 10, 2023 · In SQL Server, a recovery-only restore recovers a database without restoring a backup, typically as the last step when restoring a sequence of backups.
Manage the suspect_pages Table (SQL Server) - SQL Server
Feb 28, 2023 · This topic describes how to manage the suspect_pages table in SQL Server by using SQL Server Management Studio or Transact-SQL. The suspect_pages table is used for …
File Restores (Full Recovery Model) - SQL Server | Microsoft Learn
Sep 28, 2023 · A file restore in SQL Server is a single restore sequence that copies, rolls forward, and recovers one or more data files without restoring the whole database.
Restore Database (Files Page) - SQL Server | Microsoft Learn
Feb 28, 2023 · While restoring a database in SQL Server, use the Files page of the Restore Database dialog box to manage specific files to restore within the database.
Restore a database to a new location (SQL Server) - SQL Server
Sep 28, 2023 · This article describes how to restore a SQL Server database to a new location, and optionally rename the database in SQL Server by using SQL Server Management Studio …