Some time you Database Physical file Address and file size using sql script.
SQL Script :
You can also query for particular database name like :
Output :
SQL Script :
SELECT DB_NAME(database_id) AS DatabaseName,Name AS Logical_Name,Physical_Name,(size*8)/1024 Size_MB FROM sys.master_files
You can also query for particular database name like :
SELECT DB_NAME(database_id) AS DatabaseName,Name AS Logical_Name,Physical_Name,(size*8)/1024 Size_MB FROM sys.master_files WHERE DB_NAME(database_id) = 'TempDatabase'
Output :
No comments:
Post a Comment