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,081 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 Copy & Paste Pattern – Increasing a performance problem

By

Disclaimer: The title is my assumption because I saw it in the past happening...

Removing ad hoc plans from Query Store

By

This is not a post about the “optimize for ad hoc workloads” setting on...

Disaster recovery, tools edition

By

I just completed a chapter for another book where I spoke about the Recovery...

Read the latest Blogs

Forums

https://creativehealthcart.com/grow-extra-inches/

By traetorhaitu

Perhaps you couldn't use Grow Extra Inches to be more available. I'm searching for...

Convert Varchar to Int and SUM

By ibrahimovich87

Hi, need a request...it's possible to convert dbo.RE80_MOVSCHPUNTI.RE80_VALORE this table from nvarchar to INT...

TDE for Always on databases

By bobrooney.81

Hi All, In terms configuring and usage of TDE encryption is there a difference...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Fashion

See possible answers