5

We have a database that is in full recovery mode. The database is not in production yet so does not have a backup plan in place and is thus not being backed up. In other words, there is no existing backup. Recently, during an update, about 400 rows of data were wiped out.

Is there a way to recover those rows given that we have full transaction logging? I understand that if we had a full backup w/ transaction logs we could do a point in time recovery. Will this work if we now take a full backup of transaction logs and the database, then do a recover?

I feel like there is one path to recovery, I'm just unclear of the order in which to proceed.

Thanks for your assistance!

UPDATE: We ended up using this tool http://www.apexsql.com/sql_tools_recover.aspx I would still be interested if anyone comes across this and knows a better way. For now, we paid the price, but we got the results. Thanks for the responses!

JpMaxMan
  • 51
  • 2

1 Answers1

2

Not just using the transaction log, no. It records redo, but not undo, so you can only roll forwards from a point in time, which is the time of a backup. It may be possible to replay the entire log from the start on a blank database, but I don't know you'd "tell" SQL Server that you wanted to do that, even creating a database "for load" probably wouldn't allow it...

Gaius
  • 11,238
  • 3
  • 32
  • 64