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.
You can also bring database online by simply executing below T-SQL, however you might deal with data lose from time between last restored transaction and executing this command.
--How to get database out of Standby/readonly mode?
Restore database [YourDatabaseName] with recovery;
You can also bring database online by simply executing below T-SQL, however you might deal with data lose from time between last restored transaction and executing this command.
--How to get database out of Standby/readonly mode?
Restore database [YourDatabaseName] with recovery;
How to Remove Database Log Shipping in SQL Server - SQL Server DBA Tutorial
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.