June 15, 2012 at 4:34 am
Hi,
Can anyone suggest any way to find whether the SQL backup is through third party backup tool?
I executed the below query....but unable to find how to get.
select physical_device_name FROM msdb.dbo.backupset s
inner join msdb.dbo.backupmediafamily m
ON s.media_set_id = m.media_set_id
where name like '%DatabaseManagement%'
order by physical_device_name desc
Thanks.
June 15, 2012 at 5:11 am
There isn't a mechanism that I'm aware to gather that information from MSDB or the backup headers. I've looked for it before and haven't found it. But I could be wrong.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 15, 2012 at 5:12 am
restore it. You will come to know if its native(SQL) backup or third party.
If the backup file is of third party, you will get error which if you put on google, you will know the product it belongs to.
Sometime query is not supposed to answer all your question.
----------
Ashish
June 15, 2012 at 5:37 am
crazy4sql (6/15/2012)
restore it. You will come to know if its native(SQL) backup or third party.If the backup file is of third party, you will get error which if you put on google, you will know the product it belongs to.
Sometime query is not supposed to answer all your question.
Not necessarily. Red Gate Hyperbac is a file filter. We use the SQL SErver restore mechanisms. If you restore it to a server where Hyperbac is installed, you can't tell because the commands & everything are the same. It's only if you try to restore to a server without hyperbac that you get a problem.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply