How to view database properties, last database backup and last transaction log backup using query?
-
Hi,
I have a new project on asp.net to make a UI like the enterprise manager to create enterprise manager in asp.net.
I can already query the database properties but the database status is different, supposed to be NORMAL but the value is ONLINE.
How can I query the last database backup, last transaction log backup and maintenance plan?
Please help me...
-
hi
use the backupfile and backupset tables in msdb. i think these table should help you although i myself have not used them and dont know much about them. There are other system tables, just look in BOL.
"Keep Trying"
-
This should help you in getting latest backup taken from QA.
SELECT TOP 10 BS.backup_finish_date, BMF.physical_device_name
FROM msdb.dbo.backupmediafamily BMF
JOIN msdb.dbo.backupmediaset BMS
ON BMF.media_set_id = BMS.media_set_id
JOIN msdb.dbo.backupset BS
ON BS.media_set_id = BMS.media_set_id
WHERE BS.database_name = <DB_NAME>
AND BS.backup_finish_date
BETWEEN <FROM_DATE> AND <TO_DATE>
ORDER BY BS.backup_finish_date DESC
------------
Prakash Sawanthttp://psawant.blogspot.com
-
did you got the tables in which this info is stored?
can you share that info with us as well?
------------
Prakash Sawanthttp://psawant.blogspot.com
-
oke, thanks for the info.
I know that all the backup info is stored in MSDB db, but i was looking for some specfic query if at all you know it.
------------
Prakash Sawanthttp://psawant.blogspot.com
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply