• Do you have enough space on the source server to hold the database twice? If so you could try the following:

    - Backup the database you want to put on the destination server

    - Restored the database on the source server with a new database name

    - Shrink the restored database

    - Backup the restored database

    - Delete the restored database from the source server

    - Copy the backup over

    - Restore the backup on the destination server

    Joie Andrew
    "Since 1982"