Why Log Shipping is still a viable solution in 2016
An explanation as to what Log Shipping is and why it's still a viable solution in 2016.
2016-02-18
534 reads
Log Shipping
Faster Log Shipping Restores
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)
1,995 reads
Streamline Log Shipping Failovers: DR Made Just For You…
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,410 reads
Temporarily Change SQL Server Log Shipping Database to Read Only
I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I don't want to reconfigure Log Shipping, so is there a way to do this without redoing Log Shipping.
2015-07-07
3,197 reads
Fix SQL Server Log Shipping After a New Database File has been Added
The code in this tip will demonstrate how to continue SQL Server Log Shipping after a file has been added to the primary SQL Server database.
2014-02-05
2,846 reads
Helping Streamline Log Shipping Failovers
Using Log Shipping? Looking for a more automated way to fail over during a disaster? Read on...
2013-12-03
1,530 reads
Steps to rollback database changes without impacting SQL Server Log Shipping
When pushing a major release to a large production database, you want to know that you'll be able to rollback changes if the need arises. These are some simple steps which we can follow to ensure that we don't have to reconfigure log shipping all over again thereby saving time and ensuring systems are not affected when rolling back changes.
2013-10-23
3,892 reads
Log Shipping Lite with PowerShell
A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.
2013-07-01
4,156 reads
Adding new files to a log-shipped database (SQL Spackle)
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
2013-06-06
3,993 reads
How to move a SQL Server Log Shipped Secondary Database to Different SQL Server
This tip I will explains a step-by-step method to perform the SQL Server Log Shipping migration.
2013-03-04
2,547 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers