如果你备份了日志的话,是可以restore的,否则的话没办法了.你只能从今天开始 set your log has 'truncate log on checkpoint' option to False
2. backup your datebase
3. 不要把your log was truncated 'DUMP TRANSCATION WITH NO_LOG'
2. backup your datebase
3. 不要把your log was truncated 'DUMP TRANSCATION WITH NO_LOG'
exec sp_dboption 'csdn_test','trunc. log on chkpt.'
'csdn_test' --- 换成你的数据库
exec sp_dboption 'csdn_test','trunc. log on chkpt.',false