可以通过下面的的操作查询备份到那几个文件 use msdb select backup_set_id, name, description, database_name, server_name, logical_device_name, physical_device_name from backupset a,backupmediafamily b where a.media_set_id = b.media_set_id and database_name = '数据库名'注意:一个数据库可能有多个备份,sqlserver是通过backup_set_id来标识不同的备份的,所以恢复时只需要从backup_set_id相同的所有的文件中进行恢复.
use msdb
select backup_set_id,
name,
description,
database_name,
server_name,
logical_device_name,
physical_device_name
from backupset a,backupmediafamily b
where a.media_set_id = b.media_set_id
and database_name = '数据库名'注意:一个数据库可能有多个备份,sqlserver是通过backup_set_id来标识不同的备份的,所以恢复时只需要从backup_set_id相同的所有的文件中进行恢复.