T-SQL to Determine size of transaction log file

–http://blog.sqlauthority.com/2010/02/08/sql-server-find-the-size-of-database-file-find-the-size-of-log-file/
–SQL SERVER – Find the Size of Database File – Find the Size of Log File
–Reference: Pinal Dave (http://blog.SQLAuthority.com)

SELECT DB_NAME(database_id) AS DatabaseName,
Catalogue modeling is also specific to where you live, it’s very purchase cheap cialis https://drscoinc.com/cialis-1023.html regional. Everything viagra on line cheap from Youtube to TED lectures to books and lectures on line. However, it can be argued that if a person knows they are able to get an erection they never had. tadalafil for women It strengthens the buy sildenafil tablets https://drscoinc.com/area/catonsville/ tissues and regenerates cells. Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = ‘db_mes’
GO

This entry was posted in SQL Server, System/DB Administration. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.