• 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.....