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.

Restore database from a device containing multiple backups

Script to restore the LATEST full and differential backups from a SQL Server 2008 R2 backup device.

RE: Datatype Issues... 8000 characters is too small.

Hi Roxanne,Have you tried writing VB code that uses ADO to execute your built queries?You would need to return the SQL queries in a resultset.  So, you might add the following code at the stored procdeclare @sql_stmts table (   cols varchar(8000),   from varchar(8000),   where varchar(8000) )-- repeat insert below for each query […]

RE: Running a stored proc on table results

This actually sounds like a good idea! all I have to do now is work on creating the loop. Anybody want to provide a code sample? quote: Table data type can't be used as a parameter in stored procedures! you will have to create a loop to cyle through the table to either send an […]