2025-05-12
99 reads
2025-05-12
99 reads
2025-04-28
394 reads
This article shows how we were able to migrate a TB size database to new storage with minimal downtime.
2024-01-01 (first published: 2021-02-24)
7,761 reads
2020-12-10
412 reads
2018-06-28
861 reads
Get Logshipping report only when secondary is more than certain time behind Primary.
2017-11-14 (first published: 2017-10-27)
470 reads
2016-05-11
4,469 reads
How to move a log shipping database to a new monitor server without removing and rebuilding the log shipping setup.
2016-04-04
2,468 reads
When you’re reading from a log shipped secondary, you want the duration of restores to be as short as possible. The sproc provided switches the restores to “NORECOVERY” mode, and then switch back to “STANDBY” at the end of the process.
2015-12-11 (first published: 2015-11-23)
3,026 reads
A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.
2018-12-14 (first published: 2015-09-08)
3,689 reads
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Comments posted to this topic are about the item The Duplicate Cursor
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Comments posted to this topic are about the item Introduction of Azure SQL Hyperscale:...
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers