|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1795 Posts |
 Posted - 10/02/2012 : 01:42:25
|
To check the size of the data and log files check -
select db_name(database_id) as dbname,
type_desc,(size * 8) /1024 as size_MB,
(size * 8) /1024/1024 as size_GB
from sys.master_files order by name
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
Edited by - jackv on 10/02/2012 01:42:42 |
 |
|
SQL express 2008 R2 DB size
