SQL Server DBA Tutorial 114-How to Remove Database Log Shipping in SQL Server

preview_player
Показать описание
In this video you will learn how to remove Database Log Shipping in SQL Server using SQL Server Management Studio. It shows step by step process of checking the status of Log Shipping, removing Database from Log Shipping and bringing Secondary database online for users to use it.

Blog post link for the video:

Visit our website to check out SQL Server DBA Tutorial Step by Step
Рекомендации по теме
Комментарии
Автор

today i had a issue where there are 2 secondaries configured one with actual port number and the other without port number which does not connect actually(not sure how it took in the first place) now when i tried to remove it i couldn't and its prompting to connect to secondary without port its obviously that there is no connection -remove failing any Idea

doozydhunia
Автор

nice explanation, please share information about troubleshooting the issues in logshipping, mirroring, replication

morampudistorage
Автор

As a DBA what type of permissions should i give a user or a login for configuring log shipping, database mirroring and replications

abhishekreddygaddam