数据库备份还原到指定时间
---是完整备份.
此时应该先备份一下事务日志文件.
BACKUP LOG dbname TO DISK = 'c:\dbname.bak' WITH NO_TRUNCATE;--然后还原昨天晚上9点多的数据库备份RESTORE DATABASE dbname FROM DISK = '备份的文件' WITH NORECOVERY,REPLACE;--还原刚刚备份的事务日志,并在10点钟停止
RESTORE LOG dbname FROM DISK = 'c:\dbname.bak' WITH STOPAT = '2009-06-20 10:00:00',RECOVERY;