从sql server回滚数据 [英] rollback data from sql server

问题描述

我很遗憾地删除了来自USerinfo table.can的数据。我在sql server 2008中使用回滚获取数据

i unfortunately deleted the data from USerinfo table.can i get back the data using rollback in sql server 2008

推荐答案

No。

ROLLBACK仅与TRANSACTION一起使用 - 您启动一个事务，并在进行更改后提交它，或者在出现问题时将其回滚。如果没有在同一连接上有效的未提交事务，则无法回滚。



最好的方法是从最近的备份恢复。

如果你没有备份，那么你可能处在痛苦的世界里。其中一些可能能够帮助您：恢复已删除的数据sql server [ ^ ] - 但在尝试之前我会仔细查看，因为您可能会使问题变得更糟，而不是更好。无论哪种方式，你都在谈论很多工作...

No.
ROLLBACK is used with a TRANSACTION only - you start a transaction, and either commit it after making changes or roll it back if there is a problem. You cannot roll back without an active uncommitted transaction on the same connection.

The best way is to restore from your most recent backup.
If you don't have backups, then you are probably in a world of pain. Some of these may be able to help you: restore deleted data sql server[^] - but I'd look very carefully before trying any as you may make the problem worse, not better. Either way, you are talking about a lot of work...

最好的选择是将数据库恢复到最近的时间。

参考这个 -

如何：还原到某个时间点（SQL Server Management Studio） [ ^ ]

这也可以帮到你 -

SQL SERVER - 如何回滚SQL Server数据库更改 [ ^ ]



-KR

The best option is restore database to a most recent time.
Refer this-
How to: Restore to a Point in Time (SQL Server Management Studio)[^]
Adn this too might help you-
SQL SERVER – How to Roll Back SQL Server Database Changes[^]

-KR

这篇关于从sql server回滚数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！