SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 How to recover deleted database data?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

qingchengottawa
Starting Member

7 Posts

Posted - 10/18/2006 :  14:40:38  Show Profile  Reply with Quote
I accidentally deleted some useful data in my database. I have both .LDF and .MDF files for this database.
Is there a way to recover this database to a point of time?
Thx.

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 10/18/2006 :  15:30:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
If you have backup, then restore it. In order to restore to a point in time, you'll also need the transaction log backup that contains this data plus the entire transaction log chain since the last full backup. If you don't have these, then you'll need to purchase a third party tool such as Lumigent's Log Explorer to read the transaction log.

If you don't have a good backup solution in place, now is the time to start.

Also, you posted your question in the data corruption forum. Your problem is not with corrupted data but rather user error.

Tara Kizer

Edited by - tkizer on 10/18/2006 15:31:02
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/18/2006 :  15:31:24  Show Profile  Reply with Quote
The easiest thing to do would be to restore from the database backups to a new database, and then apply the transaction log backups up to the desired point in time. Then copy the data you need from the new database to the old one.






CODO ERGO SUM
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 10/21/2006 :  11:03:55  Show Profile  Reply with Quote
One extra possibility is that you have a Full Backup and your database is using a Recovery Model of FULL. In that case you could now take a transaction backup, and then restore Full + Transaction backups in the way that Tara and MVJ describe

Kristen
Go to Top of Page

benjo
Starting Member

8 Posts

Posted - 10/26/2006 :  04:04:47  Show Profile  Reply with Quote
they all are right but i don't have any idea.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 10/27/2006 :  13:18:37  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by benjo

they all are right but i don't have any idea.



What's the point of the post them?

Tara Kizer
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000