Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    49

    Unanswered: how to move one database file from one server to another withour restoring

    I am moving a database from one server to another. I am going to replace the old server to the new one. I heard that you can move the datfiles and put them in the same directory, and sql server will pickup the datafiles based on the system tables. Is this possible, and what are the steps to get this to work. Thanks for the help in advance.

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Have you tried these guys :sp_detach_db, sp_attach_db

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's the big deal about doing a RESTORE?
    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.

  4. #4
    Join Date
    Sep 2003
    Posts
    49
    My sql database is very large, and a restore takes 3-4 hours.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Not with Attach it won't...

    Did you look that up in BOL?
    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.

Posting Permissions

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