Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to restore .bak and .trn file against same DB?

Author  Topic 

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2008-11-07 : 10:11:16
Hi All,

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?

Please suggest.
Thanks for prompt help.

Zee

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-07 : 10:15:05
Restore Full backup with NoRecovery option
Restore Tran log backup with Recovery option.
Go to Top of Page

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2008-11-07 : 12:55:19

Thanks sodeep.

I did exactly what you suggested. But still the data look off as compare to the data at the production server.
Any idea?

Please suggest.

Thanks,

Zee
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-07 : 18:12:38
Because there has been changes in your DB from last transaction log backup. Restore recent Tran log backup .
Go to Top of Page

elliswhite
Starting Member

36 Posts

Posted - 2014-05-06 : 02:06:49
yes, you must have take the backup of the log file as well then u will be able to restore the log file. At the time of backup u need to take backup of the both files backup and log then follow steps to restore database with log file.
Go to Top of Page
   

- Advertisement -