* 가끔씩 필요한 백업파일의 백업사이즈 구하기
SELECT TOP 100
s.database_name,
m.physical_device_name,
CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSize,
CAST(DATEDIFF(second, s.backup_start_date,
s.backup_finish_date) AS VARCHAR(4)) + ' ' + 'Seconds' TimeTaken,
s.backup_start_date,
CAST(s.first_lsn AS VARCHAR(50)) AS first_lsn,
CAST(s.last_lsn AS VARCHAR(50)) AS last_lsn,
CASE s.[type] WHEN 'D' THEN 'Full'
WHEN 'I' THEN 'Differential'
WHEN 'L' THEN 'Transaction Log'
END AS BackupType,
s.server_name,
s.recovery_model
FROM msdb.dbo.backupset s
INNER JOIN msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id
WHERE s.database_name = 'ezmesG2' -- Remove this line for all the database
ORDER BY backup_start_date DESC, backup_finish_date
GO
'Brain Trainning > DataBase' 카테고리의 다른 글
[MSSQL] JDBC XA 트랜잭션 이해 (0) | 2016.04.26 |
---|---|
[MSSQL] 버전 별 페이징 쿼리 (0) | 2016.04.06 |
[MSSQL] Linked Server 패스워드 확인 (0) | 2014.10.15 |
[MSSQL] 2012 버전별 기능 (0) | 2013.09.23 |
[MSSQL] 2000 -> 2005 시스템뷰 매핑 (0) | 2013.08.05 |