Hi, i got a table which has 100,000 record and i accidentally update the record without 'Where' condition, this cause all row in this table was get affected. I don't put in 'Begin Tran', May i know do we have any way to recorver back the data ? * How about wrongly delete the record without 'where' condition, can we recorver back ? Thank You !
Sorry, you can(not) rollback , except you have a backup. if you still keep your log files, you may restore lost data There is a tool called "ApexSQL Log " , find in: http://www.apexsql.com/sql_tools_log.asp one of its features "wish you could UNDO that Update statement without a where clause!? ApexSQL Log is the Industry's most powerful recovery options for SQL Server 2005. We've helped customers recover single statements to 350 GB databases! No backups required." []