0

I have a sample database and I took a backup of that on two weeks ago. Now I wanna restore database to one day ago. I'm using the full recovery model. How can I do this with no extra features (only SSMS - use my old backup and current log)? Maybe I have to re-run my transaction log on the old database backup.

I found this but I'm not sure that is my answer or not. Can u explain this exactly for me? Or offer a better way?

Improve this question
7
  • so you have a backup from 2 weeks ago but you want to restore to yesterday? Commented Aug 19, 2017 at 6:33
  • @dbatjr yes , i think i can use my current transaction log Commented Aug 19, 2017 at 6:36
  • do you have a transaction log from yesterday? Commented Aug 19, 2017 at 6:38
  • no , may i can use today log Commented Aug 19, 2017 at 6:40
  • a tansaction log backup is just a file of all the changes. If you dont have either a transaction backup or full backup from the time that you need then you can restore to that time Commented Aug 19, 2017 at 6:41

1 Answer 1

Reset to default
0

i take backup of my current transaction log file , and then i tried to restore database for a specific time with using both old backup and transaction log , and set time plus using replace option . worked correctly!

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.