I have a problem when trying to restore a database during a platform/server
upgrade. The two installations are as follows :-
Backup from : NT Server 3.51 SP5 with SQL Server 6.0 SP3
Restore to : NT Server 4.0 SP3 with SQL Server 6.5 SP4
After restoring the dump device (approx 40MB) into the new SQL database, all
the groups/users are fine, but there is only one of about thirty tables that
have survived the transfer. I have repeated the backup/restore process a
number of times with the same result.
Is there any preparation to be done on the dump device file before I attempt
Any comments would be appreciated.