How to Transfer a Database without loosing Tables. 1

[bigdog619sd]

I am trying to copy a database from SQL7 to another SQL7 server. I am able to Backup the DB from the source and Restore at the Destination server But it is missing tables.
Afterwards I receive a Success message and No Errors from the Backup or Restore.


Source Tables 3162
Dest Tables 3047
Diff Tables 115

It's the same thing if I use DTS.
I am sure I am missing something here.

I have also tried exporting to a SQL2000 server with the same results.

MDF = 2.6Gb
LDF = 918Mb


Any ideas ?
Much Thanks

 

[mrdenny]

If you are backing up the database and restoring the database you can't be missing tables.

Try detaching the database files from the first server, copying them to the second server, then reattach them. If tables are still missing, something is very wrong. Make sure that the list of tables that you are seeing in the first server is up to date. If someone has deleted tables and you haven't manually refreshed then they won't show up.
You can run this query to check the system tables for the number of tables in the database.

select count(*)
from INFORMATION_SCHEMA.tables
where TABLE_NAME <> 'dtproperties'

This script will count all user tables in the database.

Denny

--Anything is possible. All it takes is a little research. (Me)