October 15th, 2012, 11:27 AM
Join Date: Oct 2012
Time spent in forums: 14 m 56 sec
Reputation Power: 0
Database Restore Issue
We've a DR server which is using VM machine, running Windows 2008 R2 (Standard). Had configured MS SQL Server 2008 R2 and restored the recent backup of PRD database (.bak file) into the DR server, for instance: backup of 14 Oct 2012.
We're using the following restore options:
- Most recent possible
- Overwrite existing database (WITH REPLACE)
- Leave database ready .... (RESTORE WITH RECOVERY)
After the DB restoration is completed successfully, we've checked the number of records and found they aren't tallied with our production records.
Is that true that we also need to restore the require transaction logs to fix this problem?
If yes, please advise on how to check what are the required transaction logs.
Appreciate for any of your help and advise.