Linked Questions

5
votes
2answers
151k views

How to rollback after wrong update statement in sql server 2008R2? [duplicate]

select * from aa update aa set City='chennai',LastName='vinoth'; ID FirstName LastName City 29 Abcrdrr vinoth chennai 1 John vinoth chennai 2 Joe vinoth chennai 35 ...
3
votes
4answers
9k views

How can I recover my tables in sql server database [duplicate]

I deleted 3 tables from my database with data and I have no backup. How can I restore tables with data in my database ? How can I restore tables and data with database log file?(Database recovery ...
0
votes
2answers
2k views

Recover data in a SQL Server table without backups [duplicate]

We are having a database without backup to restore. (we didn’t keep backups as client not having enough space in his SQL Server 2012). Unfortunately some data has been lost and we need to recover ...
4
votes
2answers
4k views

Recover deleted records [duplicate]

Possible Duplicate: How do I get back some deleted records? Our C#.NET application mistakenly deleted all records from all tables of its database. The application automatically takes backups, and ...
1
vote
2answers
2k views

Undo Deleted Records [duplicate]

My Database has Full BackUp Plan on Every Morning on 01:00 Am. Today I came to work and Deleted all of the Records in a table by mistake in sql server management Studio by running this command delete ...
0
votes
1answer
216 views

How to get back sql table data? [duplicate]

IDE: Microsoft SQL Server Management Studio Mistakenly I have cleaned a table data using delete from table tblBookData and now it has cleaned that table, please tell me is there any way to get back ...
0
votes
1answer
101 views

How do I recover deleted rows from one table while having Recovery SIMPLE Model? I am using Microsoft SQL Server 2014 [duplicate]

How do I recover deleted rows from a table while having Recovery SIMPLE Model? Database is in Microsoft SQL Server 2014. I have managed to find them in fn_dblog table before data is overwritten with a ...
0
votes
1answer
76 views

How Can I restore a database to a point of time without Old backup? [duplicate]

I have a database in full recovery mode with five tables. I accidentally deleted one table. I don't have any old backups. Can I restore the database with five tables?
-2
votes
1answer
64 views

Retrieve SQL statements - No backup, No query tracing [duplicate]

I know that my question probably don't belong here but I would be really so thankful if someone has the skill for solving this out. I have recently made several update statements that I shouldn't ...
2
votes
1answer
46 views

How to restore a database from the SQL 2008R2 log? [duplicate]

Today, for a great oversight, did a deal with a big mistake, which I forgot to put the WHERE keyword in the UPDATE statement... I searched in the google, I found a lot of things of how to restore the ...
2
votes
0answers
60 views

Can you recover to a point in time using the LDF? [duplicate]

Possible Duplicate: How do I get back some deleted records? A coworker accidentally ran an update statement that needs to be reverted. The last backup is about 12 hours old. Is there any way to ...
0
votes
0answers
52 views

Accidentally drop table in database that has no backup [duplicate]

One Table is accidentally dropped in my database. I had not taken backup of the database since it is in development environment. I want to restore the table. Kindly please provide any solution. The ...
36
votes
1answer
22k views

DELETE vs TRUNCATE

I am trying to get a greater understanding on the differences between the DELETE and TRUNCATE commands. My understanding of the internals goes something along the lines of: DELETE -> the database ...
12
votes
2answers
21k views

View delete statements in the Transaction log

Is it possible to view delete statements that have recently occurred in the Transaction Log?
18
votes
3answers
10k views

What other databases have a feature similar to Oracle's Flashback Query?

I am interested to know what other databases have features similar to Oracle's Flashback Query. It would seem that any database that supports MVCC could have the feature, but which do? SO has this ...

15 30 50 per page