Picture this, you're happily backing up your database to a Azure blob storage until suddenly it starts mysteriously failing with the error... Write to backup block blob device https://****** failed. Device has reached its limit of allowed blocks. What's going on, nothing's changed?! Well, it has, the database has grown and the issue that you're... Continue Reading →
All code in this post can be found in our GitHub repo https://github.com/SQLUndercover/UndercoverToolbox This is a question that's come up twice this morning, firstly where can we find a history of database snapshots and secondly where can we find a history of restores from snapshot? Frustratingly, SQL doesn't make this at all easy for us... Continue Reading →
It looks like there was a bug lurking in sp_RestoreScript that was causing the wrong ALTER DATABASE command to be generated when using @SingleUser and a WITH MOVE parameter. 1.8 fixes this issue. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/
SQL Server has given us the option to backup our databases directly to Azure BLOB storage for a while now but it's not something that I've had all that much call to use until recently. So this is just going to be a quick walk through on how you can backup your on premise SQL... Continue Reading →
In this episode, David looks at how we can encrypt our SQL Server backup files https://www.youtube.com/watch?v=Q0UdX04fHQo&feature=youtu.be
Releases seem to be coming out thick and fast at the moment, here's the latest v1.6 revision to sp_restorescript For those of you backing up to Azure BLOB Storage, we've now added a @Credential parameter. You can grab the latest version from our GitHub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql or for full documentation, visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/
We've released sp_RestoreScript 1.5. This is only a minor release but adds the type of the backup file to the output. You can grab the latest version from our GitHub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql or for full documentation, visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/
sp_restorescript v1.3 is now available. We had found instances where backups consisting of multiple backup files were causing the length of the restore command to exceed the maximum character limit. 1.3 deals with this problems. Please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ for full documentation on sp_restorescript The procedure can also be downloaded from out GitHub site https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote some time ago. I remember writing the script because from time to time I would get asked if I can restore a copy of a specific database to a particular point in time... Continue Reading →
I've been having a little play around with AWS recently and was looking at S3 (AWS' cloud storage) when I thought to myself, I wonder if it's possible to backup up an on premise SQL Server database directly to S3? When we want to backup directly to Azure, we can use the 'TO URL' clause... Continue Reading →
SQL Undercover 