Log Shipping

Faster Log Shipping Restores

  • Script

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.

5 (1)

2015-12-11 (first published: )

1,009 reads

Steps to rollback database changes without impacting SQL Server Log Shipping

  • Article

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.


3,892 reads


Reflection on Talking at SQLSaturday Charlotte About Mental Health


On December 7, I did a session on mental illness and mental health problems...

A guide to acronyms, abbreviations, and other technical terms


Here’s a list of some technical terms, acronyms, and abbreviations you may have heard,...

T-SQL Tuesday #121: Gifts received for this year


At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

Read the latest Blogs


Concurrent Queries

By WhiteLotus

Hi All, I would like to know how many concurrent queries running in SQL...

Querying Master Database DMVs in Azure SQL Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Querying Master Database DMVs in...

The Mangled Outer Join

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Mangled Outer Join

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers