InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 16:14:06 GMT20http://www.sqlservercentral.com/Forums/Topic1385256-392-1.aspx[quote][b]Ray M (11/15/2012)[/b][hr]Wouldnt the size of the database be the MDF size + the LDF size?No one minds helping, but if you want us to do your job for you, I'm sure someone is available for hire.[/quote]+1I'm available.Thu, 15 Nov 2012 20:42:36 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1385256-392-1.aspxWouldnt the size of the database be the MDF size + the LDF size?No one minds helping, but if you want us to do your job for you, I'm sure someone is available for hire.Thu, 15 Nov 2012 13:26:44 GMTRay Mhttp://www.sqlservercentral.com/Forums/Topic1385256-392-1.aspxHi thanks for your reply..but i m getting database name mdfsize ldf size but i need [b]current size of the database [/b]also could you please help me on this.Thu, 15 Nov 2012 10:08:16 GMTshiv-356842http://www.sqlservercentral.com/Forums/Topic1385256-392-1.aspxSomething like this?[code="sql"]SELECT DB_NAME(database_id) AS DatabaseName, SUM(CASE WHEN type=0 THEN size ELSE 0 END) AS MdfSize, SUM(CASE WHEN type=1 THEN size ELSE 0 END) AS LdfSizeFROM sys.master_filesGROUP BY database_id[/code]Thu, 15 Nov 2012 10:03:04 GMTMark-101232http://www.sqlservercentral.com/Forums/Topic1385256-392-1.aspxHi Team,I m looking out put like below Database Name Mdf file size Ldf File size current size of the database requesting to you guys please help me with exact script its really helpful to me. Thanks in advance..Thu, 15 Nov 2012 09:51:38 GMTshiv-356842