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...
Wow, two answers at the same time. Thanks to both of you.
I just ran that code and it's exactly what I was looking for.
-Matt / comments
Wow, two answers at the same time. Thanks to both of you.
I just ran that code and it's exactly what I was looking for.
-Matt
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...
Very nice. Thank you.
-Matt / comments
Very nice. Thank you.
-Matt
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 ...
Fantastic! That worked like a charm.
Thank you,
-Matt / comments
Fantastic! That worked like a charm.
Thank you,
-Matt
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...