CODEWITHSUNDEEP
sql-serverdatabase-backupsdatabase-restore
Simone Spagna
Simone Spagna

Reputation: 39

Recover database with no backups

I want to know if there is a way to revover the state of a database at a certain date. Unfortunately I don't have a backup.

Upvotes: 0

Views: 3233

Answers (2)

Mark Davidson
Mark Davidson

Reputation: 414

As Aaron said above there are very few things you can do here.

Why do you need to recover database to a previous state? If you deleted some data and want to undo transactions you can probably recover some data if your database was in full recovery mode.

If this is the case you can try reading transaction log using SQL Log Rescue or ApexSQL Log

Upvotes: 1

anon
anon

Reputation:

Without backups of any kind, there is nothing you can do - since previous state has been wiped away by checkpoints (even in full recovery, it acts like simple recovery until you've bothered to take a backup). This situation is precisely what backups are for. If you jump out of a plane without a parachute, don't bother looking for the ripcord...

Upvotes: 11

Related Questions