How to restore two backup (.bak and .trn file) against same database?
Posted on 2008-11-07
I have to restore a backup (which client took from the production server) that a client provided us on our own test servers. I was expecting one file, but it has the following two files.
Romp_backup_200811060204.bak (5674685 KB)
Romp_backup_200811060209.trn (827 KB)
The .trn seems to be a SQL Server transactional log backup. I restored the .bak file only, but I dont see the data that I see on the production database. Is the reason related to the fact that I did not restore .trn file? If I need to restore .trn file now, how can I do that? Is this going to resolve the problem and the data will be similar to the production database?
Thanks for prompt help.