Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to restore my database using point in time using .bak file. I selected the back from using the from device option. File is shown its type is full as i give the some back data and time. The .bak file shown disappear. what I am doing wrong here

share|improve this question

migrated from stackoverflow.com May 18 '12 at 11:48

This question came from our site for professional and enthusiast programmers.

1  
I don't backups work like that. The back up is taken at the time it is taken. To do point in time I think you need to replay transaction logs. Either way this is a question for ServerFault.com or dbadmins –  Preet Sangha May 18 '12 at 10:45
add comment

1 Answer

up vote 1 down vote accepted

For a point in time recovery, you need the series of transaction log backup files that are usually generated by regular, scheduled transation log backups in addition to the full database backup that you possess. Transaction log backups are often denoted by .bak or by .trn extensions. If you do not have those transaction log backup files, you can't do what you want. Roughly speaking, you would restore to a point in time by: 1. Restoring the full backup file using the NORECOVERY option. 2. Restore all of the relevant transaction log backups using the STOPAT option. 3. Lastly, bring the database out of recovery.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.