This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Restore from backup, urgent

Question
0

Sign in to vote

Extremely Urgent,

We ran into the delete situation at the database. Now we want to just restore one days worth of data from the backup.

Some how there was a rollback and we lost data for 1/28/09. We do have a nightly backup that runs every night, we just want to restore data from 1/28.

Please provide specific steps. Greatly appreciated. Thanks.

Thursday, January 29, 2009 11:32 PM

Answers

1

Sign in to vote
I actually wrote an entire article on this - have a look and see if this helps:

http://thehobt.blogspot.com/2008/12/recovering-deleted-data-in-sql-server.html

As Alejandro said, you probably want to go for the "restore and copy" solution. Let us know if you have any specific questions.
Aaron Alton | thehobt.blogspot.com
- Proposed as answer by Chirag Shah Friday, January 30, 2009 2:12 AM
- Marked as answer by KSkh Monday, February 2, 2009 6:41 PM
Friday, January 30, 2009 12:13 AM

All replies

1

Sign in to vote
You could restore the backup to a second db (read RESTORE statement in BOL, you need to specify new path for the files using MOVE clause) or box, and copy desired data.

AMB
- Proposed as answer by Chirag Shah Friday, January 30, 2009 2:13 AM
Friday, January 30, 2009 12:09 AM
1

Sign in to vote
I actually wrote an entire article on this - have a look and see if this helps:

http://thehobt.blogspot.com/2008/12/recovering-deleted-data-in-sql-server.html

As Alejandro said, you probably want to go for the "restore and copy" solution. Let us know if you have any specific questions.
Aaron Alton | thehobt.blogspot.com
- Proposed as answer by Chirag Shah Friday, January 30, 2009 2:12 AM
- Marked as answer by KSkh Monday, February 2, 2009 6:41 PM
Friday, January 30, 2009 12:13 AM
0

Sign in to vote

Thanks the article was helpful.

Monday, February 2, 2009 6:46 PM
0

Sign in to vote

What do you mean by

"read RESTORE statement in BOL"

What is "BOL"?

Monday, February 2, 2009 6:47 PM
1

Sign in to vote

KSkh said:
What do you mean by

"read RESTORE statement in BOL"

What is "BOL"?
BOL is Books Online. It's either the help that you installed with SQL Server, or the MDSN Books Online site: http://msdn.microsoft.com/en-us/library/ms130214.aspx

HTH...
Aaron Alton | thehobt.blogspot.com

Tuesday, February 3, 2009 1:40 AM
0

Sign in to vote

Thanks.

Friday, February 6, 2009 9:31 PM