MSSQL DB 쿼리 - 관리

최종 DB 복원 시간 알아내는 방법

SELECT * FROM msdb.dbo.restorehistory order by restore_date desc


DB 용량 알아내는 방법

SELECT b.name ,CASE type_desc
WHEN 'ROWS' THEN 'DATA' ELSE type_desc END AS 'File Type' ,SUM(size*8)/1024. AS 'SIZE(MB)'
FROM sys.master_files a JOIN sys.sysdatabases b ON a.database_id= b.dbid
WHERE database_id>=7
GROUP BY b.name,type_desc
ORDER BY b.name,a.type_desc