Akayisi (1/22/2014)
Hanshi my bad, nobody can delete it accidentally.ok now i want to know this.
Suppose that i have trn files which are 1.trn, 2.trn, 3.trn
I know for sure that last trn files that has been restored was 1.trn. But I tried to restore 2.trn manually, sqlservers says it is too recent to apply blabla......
But, I found out that on log shipping db, i have also backup job which should be working on prod db. I disabled the backup job on log ship db, but it is still not working ...
Any suggestions.....
Can you post the results of the following query when executed against the primary and secondary databases (change the dbname first)
select name, differential_base_lsn
from sys.master_files
where database_id = db_id('thedb')
and type = 0
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉