查看数据库备份历史记录

[nzperfect]

今天在翻以前贴子时，找到这贴：
http://topic.csdn.net/u/20090709/14/979e2f09-b41d-482c-81f3-0c965d1eb90c.html
发现这个代码有误：

select  server_name   ,                                                         --'服务器名'
database_name     ,                                                    
round(backup_size/1024.0/1024.0 , 2) as backup_size ,                   
backup_start_date      ,                                                
backup_finish_date    ,                                                
datediff(second , backup_start_date , backup_finish_date) as spendtime ,
type,                                                                    
m.physical_device_name  ,                                                
getdate()                                                
from msdb.dbo.backupset b join msdb.dbo.backupmediafamily m on b.backup_set_id = m.media_set_id 
where  backup_start_date > = '2009-07-01 15:39:30.933' --在这里修改时间
order by database_name,backup_start_date

更正一下：

select bst.database_name,
case when bst.type='d' then 'full'
	when [type]='i' then 'differential'
	when [type]='l' then 'log'
	when [type]='f' then 'file / filegroup'
	when [type]='g' then 'differential file'
	when [type]='p' then 'partial'
	when [type]='q' then 'differential partial'
	end
as [type],bmf.physical_device_name,
bst.backup_finish_date as backuptime,bst.first_lsn,bst.last_lsn,
bst.differential_base_lsn,bst.backup_start_date,bst.backup_finish_date,
bst.is_copy_only
from msdb.dbo.backupset bst
inner join msdb.dbo.backupmediafamily bmf on bst.media_set_id=bmf.media_set_id
where 1=1
and bst.database_name = 'dbname'
--and bst.type = 'i'
and bst.backup_finish_date > '2011-10-01'
order by bst.backup_start_date, bmf.family_sequence_number

哎，误人子弟啊

[AcHerat]

学习，更学习这种精神。

[--小F--]

学习 谢谢分享。

[Mr_Nice]

LZ心细啊....

[pengxuan]

楼主好人

[中国风]

[水族杰纶]

楼主好淫啊

[勿勿]

向LZ致敬

[快溜]

好孩子

[bzcode]

我一直使用工具来查看日志的，历史记录从来没有看过。

[Rotel-刘志东]

支持楼主了。