Viewing 5 posts - 1 through 5 (of 5 total)
You can already make simple query to retrieve the info using the tables, you only have to know the information about the table, columns and data. You can search for...
October 6, 2006 at 1:16 am
Im so sorry, not table name BUT DATABASE NAME "msdb".
October 6, 2006 at 1:11 am
Look for the table name "msdb". All information about the databases, objects are there including backups.
October 6, 2006 at 1:06 am
ITS OK ALREADY, ITS ALL ON THE TABLE MSDB. THANKS GUYS. I REALLY APPRECIATE YOUR HELP.
MAY THE FORCE BE WITH YOU...
October 6, 2006 at 1:00 am
Thanks for the reply guys. Its already work for the Last Database backup info, Im still looking to query the Last Transaction Log Backup and Maintenance Plan.
October 5, 2006 at 11:29 pm
Viewing 5 posts - 1 through 5 (of 5 total)