Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuNí thacaítear leis an mbrabhsálaí seo a thuilleadh.
Uasghrádú go Microsoft Edge chun leas a bhaint as na gnéithe is déanaí, nuashonruithe slándála, agus tacaíocht theicniúil.
Applies to:
SQL Server
This article describes the prerequisites for converting a log shipping primary database and one or more secondary databases to an Always On primary and secondary database(s).
Nóta
You can configure any primary or secondary database (possibly readable) as a log shipping primary database in an availability group.
To allow backup jobs to run on the primary replica of the availability group, use the following Always On Availability Groups backup settings:
Property | Setting |
---|---|
Automated backup preference of availability group | Only on the primary replica |
Back up priority of the primary replica. | >0 |
For more information:
View Availability Group Properties (SQL Server)
Configure Backup on Availability Replicas (SQL Server)
The log shipping primary database must reside on the instance of SQL Server that hosts the initial/current primary replica of the availability group.
For a given log shipping secondary database to be converted to an Always On secondary database, it must:
Use the same name as the primary database.
Reside on a server instance that hosts a secondary replica for the availability group.
Once the backup job has run on the primary database, disable the backup job, and once the restore job has run on a given secondary database, disable the restore job.
After you have created all the secondary databases for the availability group, if you want to perform backups on secondary replicas, you need to reconfigure the automated backup preference of the availability group.
For more information:
Converting a log shipping configuration to Availability Group (a SQL Server blog)
Log shipping
Always On Availability Groups
Use the Availability Group Wizard (SQL Server Management Studio)
Use the New Availability Group Dialog Box (SQL Server Management Studio)
Join a Secondary Database to an Availability Group (SQL Server)
Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuOiliúint
Modúl
Deploy highly available solutions by using Azure SQL - Training
In this module, you'll learn how to deploy highly available solutions by using Azure SQL. You'll also look at architectures and how they affect availability.
Deimhniú
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Doiciméadúchán
Database Mirroring and Log Shipping (SQL Server) - SQL Server Database Mirroring
Learn about the considerations for combining log shipping and database mirroring in SQL Server, including how many destination servers you need.
About log shipping (SQL Server) - SQL Server
Learn about SQL Server log shipping, which sends transaction log backups from a primary database on a primary server instance to secondary databases.
Log Shipping and Replication (SQL Server) - SQL Server
Learn how log shipping applies the transaction log from every insertion, update, or deletion made on the primary database to the secondary database.