Hello,
It seems that the system table [backupset] does *not* contain backups ma
de by our 3d party backup
tool (Veritas), but only backups made by the SQL Server tools (Q.A., Agent c
ontrolled Tasks...).
Is this true?
How can I query the backup history of the 3d party tool?
(SQL S. 2000)
Thank You
JoachimJoachim
Please refer to
backupfile, backupmediafamily, backupmediaset, backupset, restorefile,
restorefilegroup, and restorehistory.
"Joachim Hofmann" <speicher@.freenet.de> wrote in message
news:4056CD31.45AC9D4B@.freenet.de...
> Hello,
> It seems that the system table [backupset] does *not* contain backups made[/co
lor]
by our 3d party backup
> tool (Veritas), but only backups made by the SQL Server tools (Q.A., Agent
controlled Tasks...).
> Is this true?
> How can I query the backup history of the 3d party tool?
> (SQL S. 2000)
> Thank You
> Joachim|||Uri Dimant wrote:
> Joachim
> Please refer to
> backupfile, backupmediafamily, backupmediaset, backupset, restorefile,
> restorefilegroup, and restorehistory.
Thanks, I think I found the jobs. What really confuses me: The columns with
"software" in their name
always contain 'Microsoft SQL Server', in spite of the backup was made by th
e 'Veritas' Tool.
i.e:
select distinct software_name
from backupmediaset
Joachim
No comments:
Post a Comment