以前寫過一篇文章IO is frozen on database xxx, No user action is required“， 主要是介紹PlateSpin在服務(wù)器層面做DR備份時(shí)，SQL Server日志里面有"I/O is frozen on database xxxx"以及“I/O was resumed on database xxx"信息，詳細(xì)信息參考那篇博客，這篇主要是從側(cè)面一個(gè)佐證、補(bǔ)充！

其實(shí)后面發(fā)現(xiàn)，當(dāng)PlateSpin作業(yè)運(yùn)行時(shí)，你會(huì)發(fā)現(xiàn)數(shù)據(jù)庫會(huì)msdb.dbo.backupset中會(huì)會(huì)記錄一條數(shù)據(jù)庫完整備份，備份到Virtual Device的記錄。這個(gè)也是側(cè)面一個(gè)佐證！當(dāng)然更細(xì)、更深入方面的原理、知識點(diǎn)，由于網(wǎng)上PlateSpine的資料不多，自己也沒有時(shí)間去深入了解。這里只是我在采集備份信息時(shí)，發(fā)現(xiàn)的一個(gè)細(xì)節(jié)而已，當(dāng)時(shí)很是納悶，那個(gè)時(shí)間點(diǎn)沒有做全備、也沒有備份到虛擬設(shè)備（Virtual Device）啊？后面查找原因，才發(fā)現(xiàn)這個(gè)跟PlateSpin有關(guān)系。特此記錄一下！

SELECT  CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS servername ,
        bs.database_name ,
        bs.backup_start_date ,
        bs.backup_finish_date ,
        DATEDIFF(MINUTE,bs.backup_start_date, bs.backup_finish_date) AS backup_consume_time,
        bs.expiration_date ,
        CASE bs.type
          WHEN 'D' THEN 'Full Backup'
          WHEN 'I' THEN 'Diff Backup'
          WHEN 'L' THEN 'Log  Bacup'
          WHEN 'F' THEN 'File Backup'
          WHEN 'G' THEN 'File Diff'
          WHEN 'P' THEN 'Partial Backup'
          WHEN 'Q' THEN 'Partial Diff Backup'
        END AS backup_type ,
        CASE bf.device_type 
          WHEN 2 THEN 'Disk'
          WHEN 5 THEN 'Tape'
          WHEN 7 THEN 'Virtual Device'
          WHEN 105 THEN 'permanent backup device'
        END AS backup_media,
        bs.backup_size/1024/1024/1024  AS [backup_size(GB)] ,
        bs.compressed_backup_size/1024/1024/1024 AS [compressed_backup_size(GB)],
        bf.logical_device_name ,
        bf.physical_device_name ,
        bs.name AS backupset_name ,
        bs.first_lsn,
        bs.last_lsn,
        bs.checkpoint_lsn,
        bs.description
FROM    msdb.dbo.backupmediafamily bf
        INNER JOIN msdb.dbo.backupset bs ON  bf.media_set_id = bs.media_set_id
WHERE   ( CONVERT(DATETIME, bs.backup_start_date, 102) >= CAST('2017-10-18 21:00' AS DATETIME))
     AND ( CONVERT(DATETIME, bs.backup_start_date, 102) <= CAST('2017-10-18 23:59' AS DATETIME))
 AND 
 bs.type='D' AND bs.database_name='HistoryData'
ORDER BY bs.database_name ,
         bs.backup_finish_date;

以上就是PlateSpin備份時(shí)SQL Server的信息介紹的詳細(xì)內(nèi)容，更多請關(guān)注php中文網(wǎng)其它相關(guān)文章！