PlateSpin备份服务器时SQL金沙官网线上 Server的一些

 

        bs.backup_start_date ,

        CASE bf.device_type

 

     AND ( CONVERT(DATETIME, bs.backup_start_date, 102) <= CAST('2017-10-18 23:59' AS DATETIME))

        bf.logical_device_name ,

ORDER BY bs.database_name ,

          WHEN 7 THEN 'Virtual Device'

FROM    msdb.dbo.backupmediafamily bf

        bs.checkpoint_lsn,

          WHEN 'I' THEN 'Diff Backup'

          WHEN 'G' THEN 'File Diff'

          WHEN 5 THEN 'Tape'

        bf.physical_device_name ,

          WHEN 'D' THEN 'Full Backup'

 

金沙官网线上 1

 

        bs.description

        bs.database_name ,

          WHEN 'F' THEN 'File Backup'

        bs.backup_size/1024/1024/1024  AS [backup_size(GB)] ,

        bs.compressed_backup_size/1024/1024/1024 AS [compressed_backup_size(GB)],

以前写过一篇文章IO is frozen on database xxx, No user action is required“, 主要是介绍PlateSpin在服务器层面做DR备份时,SQL Server日志里面有"I/O is frozen on database xxxx"以及“I/O was resumed on database xxx"信息,详细信息参考那篇博客,这篇主要是从侧面一个佐证、补充!

 AND

        bs.expiration_date ,

 

          WHEN 'L' THEN 'Log  Bacup'

        CASE bs.type

 bs.type='D' AND bs.database_name='HistoryData'

        END AS backup_type ,

WHERE   ( CONVERT(DATETIME, bs.backup_start_date, 102) >= CAST('2017-10-18 21:00' AS DATETIME))

         bs.backup_finish_金沙官网线上,date;

          WHEN 'P' THEN 'Partial Backup'

 

        bs.name AS backupset_name ,

金沙官网线上 2

        END AS backup_media,

SELECT  CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS servername ,

        bs.last_lsn,

          WHEN 2 THEN 'Disk'

其实后面发现,当PlateSpin作业运行时,你会发现数据库会msdb.dbo.backupset中会会记录一条数据库完整备份,备份到Virtual Device的记录。这个也是侧面一个佐证!当然更细、更深入方面的原理、知识点,由于网上PlateSpine的资料不多,自己也没有时间去深入了解。这里只是我在采集备份信息时,发现的一个细节而已,当时很是纳闷,那个时间点没有做全备、也没有备份到虚拟设备(Virtual Device)啊?后面查找原因,才发现这个跟PlateSpin有关系。特此记录一下!

          WHEN 'Q' THEN 'Partial Diff Backup'

          WHEN 105 THEN 'permanent backup device'

 

        DATEDIFF(MINUTE,bs.backup_start_date, bs.backup_finish_date) AS backup_consume_time,

        INNER JOIN msdb.dbo.backupset bs ON  bf.media_set_id = bs.media_set_id

        bs.backup_finish_date ,

        bs.first_lsn,

本文由金沙官网线上发布于数据库,转载请注明出处:PlateSpin备份服务器时SQL金沙官网线上 Server的一些

您可能还会对下面的文章感兴趣: