Bacakuplar Hakkinda Detayli bilgi - Backup Information
Definition Description
SELECT bus.server_name as 'server', bus.database_name as 'database', CAST(bus.backup_size /1024/1024/1024 AS DECIMAL(10,2)) as 'buSize_GB', CAST(DATEDIFF(ss, bus.backup_start_date,bus.backup_finish_date) AS VARCHAR(10)) as 'buDuration_Sec', bus.backup_start_date as 'buDateStart', bus.backup_finish_date as 'buDateFinish', CAST(bus.first_lsn AS VARCHAR(50)) as LSN_First, CAST(bus.last_lsn AS VARCHAR(50)) as LSN_Last, CASE bus.[type] WHEN 'D' THEN 'Full' WHEN 'I' THEN 'Differential' WHEN 'L' THEN 'Transaction Log' WHEN 'F' THEN 'File\FileGroup' WHEN 'G' THEN 'Differential File' WHEN 'P' THEN 'Partial' WHEN 'Q' THEN 'Differential Partial' END AS buType, bus.begins_log_chain , bus.differential_base_lsn, bus.recovery_model, bume.physical_device_name, is_snapshot FROM msdb.dbo.backupset bus INNER JOIN msdb.dbo.backupmediafamily bume ON bus.media_set_id = bume.media_set_id WHERE bus.database_name = DB_NAME() ORDER BY bus.backup_start_date DESC, bus.backup_finish_date DESC; GO
