Results 1 to 2 of 2

Thread: moving...

  1. #1
    Join Date
    Feb 2002
    Posts
    17

    Unanswered: moving...

    Hi ,

    We have a database around 5GB in size, located in remote location . i want to get that database into my local machine. We cannot take back up in tape or any other media from our remote location ,so we have to depend on FTP .

    Is there any better solution other than FTP, or DTS import/Export , to transfer whole database to my local machine ?

    Please give me some suggestions !

    Thanks,

    Hadley

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Its better to take file backup and use FTP to transfer the file. Before than make sure to run DBCC checks against the database to keep it clean.

    Even you can use Generate SQL Scripts and run those scripts on the local machine, then use DTS to transfer the data.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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