Home
Blogs
Forums
Browse by Tags
All Tags
»
tsql
»
log file
data file
TSQL to compare log file to data file in a database
SELECT @@servername as ServerName , db_name ( database_id ) as DatabaseName , Name as LogiCalFileName , Physical_Name [Physical file] , ( size * 8 )/ 1024 [Size_MB] FROM sys.master_files...(read more)
Posted to
SQL Server Aggregator
(Weblog)
by
Anonymous
on
August 1, 2007
Copyright © 2008 wardyit.com. All rights reserved.