SQL SERVER-数据库备份及记录

佚名 6年前 (2019-05-16) 随笔 1643人围观抢沙发百度已收录

--完整备份
BACKUP DATABASE JINWEI TO DISK='D:\BAK\JINWEIFULL.bak'

--日志备份
BACKUP LOG JINWEI TO DISK='D:\BAK\JINWEILOG.bak'

--差异备份
BACKUP DATABASE JINWEI TO DISK='D:\BAK\JINWEIDIFF.bak' WITH DIFFERENTIAL



--查看备份记录
--type  D:数据库备份  I；差异备份  L：日志备份  F：文件备份
SELECT DISTINCT S.FIRST_LSN,S.LAST_LSN,S.DATABASE_BACKUP_LSN,s.backup_finish_date,s.type,y.physical_device_name
FROM msdb..backupset AS S
INNER JOIN msdb..backupfile AS f ON f.backup_set_id=s.backup_set_id 
INNER JOIN msdb..backupmediaset AS m ON S.media_set_id=M.media_set_id
INNER JOIN msdb..backupmediafamily AS y ON m.media_set_id=y.media_set_id
WHERE (s.database_name='JINWEI')
ORDER BY s.backup_finish_date DESC