-- Parent table Table A.

Insert into Table A

(Column b, Column c, Column d)

Values

(cxxxx, jdf, 1234)

-- Column a is the Primary key (also an Identity column) for Table A. Identity...

>> How are you getting these records?

for Table A, explicit Insert statement will be executed by me. There are just 2 records to be Inserted into Table A.

for other tables,...

To continue this:

Schema: 6 Tables: A, B, C, D, E, F

Table A: Parent tables to B, C, & D.

Table B: Parent to none.

Table C: Parent to none.

Table D: Parent to...

Thanks for you replies.

I apply the full backup with "norecovery" and apply Differential backup with "recovery". There is no requirement to apply transaction log backups.

Executed as user: TDS\clusadminspain. Cannot apply...