Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    17

    Unanswered: Remote to Remote

    Hi,

    We have 3 database server . one is local and other two are in two different locations.

    Scenario is , we have to import a database from one old remote server to another new remote server.
    Since, it should be difficult (bcoz of firewall issues) to import from old remote to new remote server, i thought to
    import to my local DB server then import database to new remote server.

    I am planning to give IMPORT/EXPORT option in the ALL TASKS property, from my local m/c to the old remote server.
    then take BACKUP database in my local machine . After that just copy the backup file to my new Remote server and then
    just restore it.

    Or is there any better solution to accomplish this ?

    Please give me some advice !

    Thanks,

    Hadley

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Why not consider using REPLICATION or LOG SHIPPING kind of solution rather depending on roundabout solution. Refer to books online for more information.
    --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
  •