patternModerate
Can I restore a database to a point of time without backup?
Viewed 0 times
canwithoutpointtimedatabaserestorebackup
Problem
I have an SQL 2005 database with logging set to FULL but without any backups. Is it possible to restore it to a point of time?
Solution
I had a database using the simple recovery model, that had never been backed up.
I deleted some things that I shouldn't have and came to this thread and after reading it my heart was in my throat thinking of #1 telling the client and #2 all the work I'd be putting in to replace the data.
I continued to have a look on google and found ApexSQL recover. Link
I detached the database, took a copy of the detached data and log files then reattached the original and then ran the program. I told it the database and pointed it at the copy of the detached log file. It found all the deletions and scripted the recovery.
All in all, I'm very happy with the product and would recommend it to anyone. There is a 14 day trial, but it only recovers 1 in 10 rows.
I deleted some things that I shouldn't have and came to this thread and after reading it my heart was in my throat thinking of #1 telling the client and #2 all the work I'd be putting in to replace the data.
I continued to have a look on google and found ApexSQL recover. Link
I detached the database, took a copy of the detached data and log files then reattached the original and then ran the program. I told it the database and pointed it at the copy of the detached log file. It found all the deletions and scripted the recovery.
All in all, I'm very happy with the product and would recommend it to anyone. There is a 14 day trial, but it only recovers 1 in 10 rows.
Context
StackExchange Database Administrators Q#11167, answer score: 12
Revisions (0)
No revisions yet.