Theo Ekelmans

  • Interests: SQL, Hardware... especially if it comes in TBs, Anything written by Sir Terry Patchett, IOT, dabbeling in C#...... aaaand, ill stop here :)

Technical Article

Version independent spGetBackupDateFromFile

This is an version independent stored procedure to get the backup date from a backup file.

It's tested for SQL 2005, 2008(R2), 2012 and 2014.

Consider it a template to which you can add more output parameters from the headerinfo to meet your requirements.

You rated this post out of 5. Change rating

2016-04-21 (first published: )

347 reads


The 5 Best SQL Course for Beginners – Reviews and Guide


In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...

Speaking at SQL Saturday Boston 2023


I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

SQL Prompt Quick Access to Helper Code


We’ve been doing some events as part of the Redgate Roadshow, and at one...

Read the latest Blogs


checkdbcc date for all database

By lan2022nguyen

CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...

Azure Postgres reliability/management experiences

By CreateIndexNonclustered

I am considering implementing an Azure Postgres DB for use in a part of...

Unable to deploy DACPAC

By LearningDBA

Every time the dev team runs their dacpac, they encounter an issue. "This deployment...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers