124420294 (10/26/2016)

---

Hi Guys,

I have a issue of applying sql transaction log to database. For example,

a) create a database "testdb"

b) BACKUP DATABASE testdb to "d:\testdb.bak"

c) add data to testdb, add table and add record or something.

d) BACKUP log testdb to "d:\testdb_log1.trn"

e) add data to testdb, add table and add record or something.

f) BACKUP log testdb to "d:\testdb_log2.trn"

Start to restore

a) restore database testdb from disk "d:\testdb.bak" with RECOVERY option.

Now I using RECOVERY instead of NORECOVERY on purpose. And the testdb is on normal state.

My problem is how can I apply the rest .trn log files( d:\testdb_log1.trn and d:\testdb_log2.trn) to database

I use VSS to bring database to Restoring state, and then apply log files.

It reports error like "Could not redo log record (39:386:8), for transaction ID (0:0), on page (1:6), allocation unit 6488064, database 'testdb' (database ID 21). Page: LSN = (39:386:2), allocation unit = 6488064, type = 16. Log: OpCode = 7, context 24, PrevPageLSN: (39:223:9). Restore from a backup of the database, or repair the database.”