Task pad view data - question

[katbear]

Hi,

Is there a way to see the same data one sees in TASK PAD (in 2000), as there is in 2005?

I have (or had) a script that did this, but I can't find it now - arggghh.

I just want to be able to see when the LAST LOG backup occurred, but task pad doesn't exist in 2005.

Thanks

 

[mrdenny]

You can find that in the msdb database.

The tables are:
backupfile
backupfilegroup
backupmediafamily
backupmediaset
backupset

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

There are also standard reports that come with 2005. Right click on the database and select tasks -> Reports

- Paul
- If at first you don't succeed, find out if the loser gets anything.