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.

(1)

You rated this post out of 5. Change rating

2015-12-11 (first published: )

3,101 reads

Blogs

Databases and AI Agents

By

As part of my wider work exploring Claude Code and AI-assisted database engineering, I...

Creating a Pulsing Conducting Baton - Part 1

By

Train Wreck The last time I watched a high school band nearly fall apart mid-performance...

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

By

If you are considering any of the ISACA AI certs like the Advanced Artificial...

Read the latest Blogs

Forums

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

By Sanket Parmar

Comments posted to this topic are about the item Why Your Index Isn't Being...

Distance Metric Algorithms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Distance Metric Algorithms

What Can AI Really Do?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What Can AI Really Do?

Visit the forum

Question of the Day

Distance Metric Algorithms

What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?

See possible answers