SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to restore .bak and .trn file against same DB?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

zeeshan13
Constraint Violating Yak Guru

USA
347 Posts

Posted - 11/07/2008 :  10:11:16  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

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

zeeshan13
Constraint Violating Yak Guru

USA
347 Posts

Posted - 11/07/2008 :  12:55:19  Show Profile  Reply with Quote

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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 11/07/2008 :  18:12:38  Show Profile  Reply with Quote
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 - 05/06/2014 :  02:06:49  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000