Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja jezika SQL, platforme Fabric i platforme Power BI. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danasOvaj preglednik više nije podržan.
Nadogradite na Microsoft Edge da iskoristite najnovije osobine, sigurnosna ažuriranja i tehničku podršku.
Applies to:
SQL Server
This topic describes how to remove a log shipping secondary database in SQL Server by using SQL Server Management Studio or Transact-SQL.
In This Topic
Before you begin:
To remove a log shipping secondary database, using:
The log-shipping stored procedures require membership in the sysadmin fixed server role.
Connect to the instance of SQL Server that is currently the log shipping primary server and expand that instance.
Expand Databases, right-click the log shipping primary database, and then click Properties.
Under Select a page, click Transaction Log Shipping.
Under Secondary server instances and databases, click the database you want to remove.
Click Remove.
Click OK to update the configuration.
On the primary server, execute sp_delete_log_shipping_primary_secondary to delete the information about the secondary database from the primary server.
On the secondary server, execute sp_delete_log_shipping_secondary_database to delete the secondary database.
Bilješka
If there are no other secondary databases with the same secondary ID, sp_delete_log_shipping_secondary_primary is invoked from sp_delete_log_shipping_secondary_database and deletes the entry for the secondary ID and the copy and restore jobs.
On the secondary server, disable the copy and restore jobs. For more information, see Disable or Enable a Job.
About Log Shipping (SQL Server)
Log Shipping Tables and Stored Procedures
Događaji
M03 31 23 - M04 2 23
Najveći događaj učenja jezika SQL, platforme Fabric i platforme Power BI. 31. mart - 2. april Koristite kod FABINSIDER da uštedite 400 dolara.
Registrirajte se danasObučavanje
Modul
Migrate SQL Server workloads to Azure SQL Database - Training
Learn the essentials of Azure SQL Database deployment and migration. Explore its benefits, exclusive features, and migration options while optimizing performance and application connections for a smooth transition to the cloud.
Certifikacija
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.
Dokumentacija
Remove Log Shipping (SQL Server) - SQL Server
Learn how to remove log shipping by using SQL Server Management Studio or Transact-SQL in SQL Server.
Add log shipping secondary - SQL Server
Describes how to add a secondary database to an existing log shipping configuration by using SQL Server Management Studio or Transact-SQL in SQL Server.
Monitor Log Shipping (Transact-SQL) - SQL Server
Learn which tables store history containing monitoring information and stored procedures for monitoring log shipping in SQL Server.