Sql Server及时恢复数据库 [英] Sql Server Restoring database in time

问题描述

我在Sql server数据库中遇到问题，实际上我写了一个错误的更新查询，并且还在同一个数据库中恢复了以前的日期备份，但我需要更早的时间使用相同的数据库数据。

解决方案

如果你没有所需点的备份，那么你就被软管了。 SQL Server不保留任何类型的展开历史记录，返回的唯一方法是使用正确的备份返回。

如果要在一段时间内恢复数据库那么请看下面

http：// technet .microsoft.com / zh-CN / library / ms190982（v = sql.90）.aspx [ ^ ]

和

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmflash.htm [ ^ ]

I have a problem in Sql server Database, Actually I write a wrong update query and also restore previous date backup in same database but i need a same database data earlier time.

解决方案

If you don't have a backup of the point you need, then you're hosed. SQL Server does not keep any sort of unwind history, the only way to 'go back' is to have the right backup to go back to.

if you want to restore database in a time then pl look following
http://technet.microsoft.com/en-US/library/ms190982(v=sql.90).aspx[^]
and
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmflash.htm[^]

这篇关于Sql Server及时恢复数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！