Tag Archives: sysaltfiles

Different ways to find Data, log and DB Size

Different ways to get the size of the data , log files and Databases Using Counters Querying sysaltfiles & sys.databases Querying sys.master_files   SELECT instance_name AS DatabaseName, [Data File(s) Size (KB)]/1024.00 [DataInMB], [LOG File(s) Size (KB)]/1024.00 [LogInMB], [Data File(s) Size (KB)]/1024.00 … Continue reading

Posted in SQL, sysfiles | Tagged , , | 4 Comments

SQL – Query to find data,log,Total Size and other Useful information of all databases – SQL 2000/2005/2008/R2

I’ve encountered a situation where I need to find out the database file,log file, total size and other useful information about a database on SQL Server 2000/2005/2008/R2 versions. The requirement is to use same query and it has to be … Continue reading

Posted in SQL, T-SQL | Tagged , , , | 10 Comments