sp_RestoreScript 1.2 is now available HERE and on GitHub Changes include Service Broker options and the ability to restore a database in stand by, along with a couple of bug fixes.
"I just tried restoring a copy of my database but now the original's in recovery" That was the panicked question that I was asked earlier today and as it's something that I've seen come up more than a couple of times, I thought I'd write up a lunchtime quickie to explain the issue. If you... Continue Reading →
Holy Database Restores Batman, sp_RestoreScript 1.1 is now available in the Undercover Toolbox and at UNDERCOVER TOOLBOX: sp_RestoreScript – A Painless way to generate SQL Server database restore scripts. This update fixes an issue that we've found when running on SQL Servers prior to 2016.
(Version 1.2 - 30 Jan 2018) I'm sure we've all been there, we need to restore a database to 11:34am, four days ago. What's the first step? To go off hunting down the relevant full and differential backups and then figure out what transaction logs we need to play in and in what order. Well... Continue Reading →