sql server数据库事务日志备份与恢复

广告：

BACKUP LOG [mvcelec] TO DISK = 'C:\databak\mvcelec.trn'

ALTER DATABASE [mvcelec2] SET MULTI_USER;

RESTORE DATABASE [mvcelec2] FROM DISK = 'C:\databak\mvcelec.bak' WITH NORECOVERY

RESTORE LOG [mvcelec2] FROM DISK = 'C:\databak\mvcelec.trn' WITH RECOVERY

RESTORE DATABASE [mvcelec2] WITH RECOVERY;

广告：