--备份数据库
backup database 数据库 to disk='c:\db.bak'--备份事务日志
backup log 数据库 to disk='c:\dblog.bak'
--恢复数据库完整备份
restore database 新数据库 from disk='c:\db.bak'
with norecovery,
move '逻辑文件名' to 'mdf文件新位置',
move '逻辑日志名' to 'ldf文件新位置'--恢复事务日志
declare @time datetime
set @time='2005-09-01 00:00:00'
restore log dbase from disk='c:\testlog.bak'
with recovery,stopat=@time
backup database 数据库 to disk='c:\db.bak'--备份事务日志
backup log 数据库 to disk='c:\dblog.bak'
--恢复数据库完整备份
restore database 新数据库 from disk='c:\db.bak'
with norecovery,
move '逻辑文件名' to 'mdf文件新位置',
move '逻辑日志名' to 'ldf文件新位置'--恢复事务日志
declare @time datetime
set @time='2005-09-01 00:00:00'
restore log dbase from disk='c:\testlog.bak'
with recovery,stopat=@time
backup database 数据库 to disk='c:\db.bak'--备份事务日志
backup log 数据库 to disk='c:\dblog.bak'
--恢复数据库完整备份
restore database 新数据库 from disk='c:\db.bak'
with norecovery,
move '逻辑文件名' to 'mdf文件新位置',
move '逻辑日志名' to 'ldf文件新位置'--恢复事务日志
declare @time datetime
set @time='2005-09-01 00:00:00'
restore log 新数据库 from disk='c:\dblog.bak'
with recovery,stopat=@time