这篇文章将为大家详细讲解有关PlateSpin备份时SQL Server的信息是怎么样的，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。

PlateSpin在服务器层面做DR备份时，SQL Server日志里面有"I/O is frozen on database xxxx"以及“I/O was resumed on database xxx"信息。

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

SELECTCONVERT(CHAR(100),SERVERPROPERTY('Servername'))ASservername,bs.database_name,bs.backup_start_date,bs.backup_finish_date,DATEDIFF(MINUTE,bs.backup_start_date,bs.backup_finish_date)ASbackup_consume_time,bs.expiration_date,CASEbs.typeWHEN'D'THEN'FullBackup'WHEN'I'THEN'DiffBackup'WHEN'L'THEN'LogBacup'WHEN'F'THEN'FileBackup'WHEN'G'THEN'FileDiff'WHEN'P'THEN'PartialBackup'WHEN'Q'THEN'PartialDiffBackup'ENDASbackup_type,CASEbf.device_typeWHEN2THEN'Disk'WHEN5THEN'Tape'WHEN7THEN'VirtualDevice'WHEN105THEN'permanentbackupdevice'ENDASbackup_media,bs.backup_size/1024/1024/1024AS[backup_size(GB)],bs.compressed_backup_size/1024/1024/1024AS[compressed_backup_size(GB)],bf.logical_device_name,bf.physical_device_name,bs.nameASbackupset_name,bs.first_lsn,bs.last_lsn,bs.checkpoint_lsn,bs.descriptionFROMmsdb.dbo.backupmediafamilybfINNERJOINmsdb.dbo.backupsetbsONbf.media_set_id=bs.media_set_idWHERE(CONVERT(DATETIME,bs.backup_start_date,102)>=CAST('2017-10-1821:00'ASDATETIME))AND(CONVERT(DATETIME,bs.backup_start_date,102)<=CAST('2017-10-1823:59'ASDATETIME))ANDbs.type='D'ANDbs.database_name='HistoryData'ORDERBYbs.database_name,bs.backup_finish_date;

关于“PlateSpin备份时SQL Server的信息是怎么样的”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，使各位可以学到更多知识，如果觉得文章不错，请把它分享出去让更多的人看到。