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.
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 optionRestore Tran log backup with Recovery option. |
|
|
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 |
|
|
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 . |
|
|
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. |
|
|
|
|
|