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: )

880 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

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

SSRS page number by a certain column grouping

By Siten0308

Hello, I have been givin a task and not sure how to handle this,...

Best Work from Home training najafgarh

By ParminderSingh

Some work from home jobs require a bit of skill, experience, or credentials while...

SQL -> Oracle Linked Server DTC Error

By GonnaCatchIT

Dear Team, I am migrating from SQL 2008 to SQL 2014 for one of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers