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,269 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.

2013-10-23

3,892 reads

Blogs

T-SQL Tuesday #129 – Let’s Build a Time Capsule

By

It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...

Daily Coping 11 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Why a 60GB Database Backup Grew to 1TB in Size

By

Recently, I was alerted to a network file share that was running low on...

Read the latest Blogs

Forums

COPY Activity Failing

By SSCNewbee

Hi All I am copying from DLS to SQLMI and my COPY activity is...

multiplied columns from Oracle linked server

By cphite

  Wasn't sure exactly where to put this one... We populate an Oracle data...

Job that runs slow how to use more CPU

By sqlfriend

We have a web application job that runs from web calling to update database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The D in ACID

See possible answers