Navision 3.70 Failed Restoration - Odd Problem

Trying to move a client to a new server this weekend and have run into an odd problem.

I created the database (120GB database made up of 4 files named database1.fdb-database4.fdb each 30Gb each).

I backed up the old database making sure everything was being backed up.

Started the restoration of the old database into the new server. It ran for a fair while but fell over on the User table. There is a new field in that table we have added which is a boolean field.

We get the error "You cannot delete or change the type of RF (in the User table) before the value in the field is reduced to 0 (zero)".....

Now what I don't get is that this is a brand new database. It isn't changing the field type of the RF field it is simply creating the field and adding the objects to it.

The error seems to happen pretty late in the restore process (either during or after the creating of the keys).

Another point to note is that the object numbers seem out. I tried looking at the User Setup table in the new database but got a permission error. When I had a look the User Setup table has the number 1000000091 instead of 91 like it usually would. Not sure if that is just something the restore process does to stop people accessing the tables during the restore or if something else has gone wrong.

First time this happen I thought the backup/restore might have corrupted so I backed it up again and tried again but appears the same problem has occurred.

Any help would be appreciated, thanks.

So anyone had this problem before when they've made changes to the security tables and then tried to do a restore? I haven't tried doing a restore without restoring the security tables yet because I've restored this database from live to test multiple times before without this problem.