How can we help you today? How can we help you today?
matt.stanford

Activity overview

Latest activity by matt.stanford

Restoring only the data files of a backup
I'm trying to find out if it is possible to restore only the data files from a full database backup. My issue is that on our production servers I have the transaction logs blown out to a fairly la...
1 follower 1 comment 0 votes
How to find out what version of SQL Backup is installed
I'm trying to figure out how to programmatically query for the correct version of SQL Backup. My end goal is that I want to automatically fire off some TSQL when the version is X. Is there a way to...
3 followers 3 comments 0 votes
RESTORE FILELISTONLY data types
I've been having trouble guessing the data types for the result set of the RESTORE FILELISTONLY result set. Can anyone shed some light on this? I'm not using all of the columns, so I defaulted to ...
2 followers 2 comments 0 votes
How to extract the database name from a backup file
I'm trying to figure out how to retrieve the database name from the header of a backup using TSQL. The issue I'm running into is that the sqlbackup procedure returns two datasets. For example, wit...
2 followers 2 comments 0 votes