Follow two step before you make a backup to move to new server.

Step 1:
ALTER DATABASE <User DB> SET ENCRYPTION OFF

Step 2:
USE <User DB>
GO

Reply to Vinod:

Vinod, I don not get primary key violation on individual field. I get primary key violation on the combination of the fields.

As you can see from my...

Reply to Ian Yates:

I get error message that says following First:

Table error: Database ID 5, object ID 1314869659, index ID 0. Chain linkage mismatch. (1:469714)->next = (1:345947), but (1:345947)->prev =...

Thanks SQLBill for the fast reply... it worked.... I just have forgot the DBO.

Two Things here.

First your TRAN log file has to be smaller than the .MDF file.

Second, Go to your database option and turn of the AUTO GROW on your...