백업기록

백업기록

    백업기록 조회

    MSSQL 2005 이상부터 사용이 가능합니다. IF OBJECT_ID('TEMPDB..#TMP_BACKUPHISTORY') IS NOT NULL DROP TABLE #TMP_BACKUPHISTORY SELECT * INTO #TMP_BACKUPHISTORY FROM (select s.server_name, s.database_name, workname = s.name, s.backup_set_id, s.backup_finish_date,mdf_file=f.physical_name , backup_file = m.physical_device_name ,f.file_sizefrom msdb..backupset s, msdb..backupmediafamily m , msdb..backupfile fwhere..