Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Posts
    12

    Unanswered: Copy Large Database

    Does anyone know of a good way to copy a large database or backup of a database (~10 GB) across long distances (transatlantic) in a minimal amount of time?

    I have tried regular file copies, BCP, DTC, my own handwritten extraction utility, PCAnywhere, and several file splitters, all to no avail. To complicate things, the source is SQL 7 with a different code page from the destination, which is SQL 2K. The file copies always seem to get interrupted after several hours.

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Exclamation Copy Large Database

    How about some form of replication. That way the live data is now checked and the copy come from a backup.

  3. #3
    Join Date
    Mar 2004
    Posts
    12

    Copying Large Databases

    Thanks for the response. The situation here is that these are 24x365 production databases with high levels of activity that support manufacturing production, so replicating on an ongoing basis will be costly to the site. I'd really prefer some method of capturing a snapshot.

    Add to that the fact that since it is 24x365, getting time to try things is at a premium. Many of the solutions I spoke of earlier worked well in test environments where the geographical distances were a few hundred miles, but broke down when going cross-country or transatlantic.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Dump and zip and ftp?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Mar 2004
    Posts
    12
    Yeah, I think that's about the only thing left. Docs all say that DUMP and BACKUP are synonymous; is that true?

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    yeah...dump is a 6.5 term....just habit...

    Did you mention something about a different collation?

    If it is, I don't think you'll be able to RESTORE it....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    May 2004
    Posts
    7
    if you use SQLLitespeed (or other utilities allowing compression while backup is being taken)- you can always compress it on the fly here, ace or rar the resulting backup , ftp it over and extract on the other side.


    simas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •