Retrieve Database Size

[TomBarrand]

Is there anyway that you can find out the size of a database, last time it was backed up (any other useful info), basically the info you get if you are in Enterprise Manager and you select the Properties of a db and return this info to an ASP page for example?

Maybe there is a system stored procedure that can give some of this info?

Thanks

 

[Gauss]

Hi Tom!

Here are some suggestions to get DB-Info by T-SQL:

exec sp_helpdb [DB-Name]

select * from sysfiles

select database_name, max(backup_finish_date) from msdb.dbo.backupset
group by database_name order by 1

Please let me know if it helps.

 

[TomBarrand]

This is very useful

Thanks for your help

 

[SQLBill]

You might also want to look at sp_spaceused. Check it out in Books Online.

-SQLBill