Log Shipping

Technical Article

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,775 reads

Blogs

Daily Coping 28 Oct 2021

By

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

The DBA as a helpdesk.

By

Every one and again you will see people asking What skill do you think...

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Update table FirstName & LastName from Email addresses

By DaveBriCam

I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field...

SQL Instance Aliases - Urgent assistance needed please

By Brandie Tarvin

I have a migration problem. I cannot get my SQL Server instance aliases to...

Error connecting using AlwaysON Listener

By Arsh

Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers