SQL Server 2005 — Move Data to Another Machine?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: SQL Server 2005 — Move Data to Another Machine?

  1. #1
    Join Date
    Nov 2004
    Posts
    38

    SQL Server 2005 — Move Data to Another Machine?

    I'm trying to recover from a machine crash and move my SQL Server 2005 data to a new machine.

    I had SQL Server 2005 (developer's edition) on the old machine and now have installed it in the new. Is there a good way to transfer the old system info and data to that new machine?

    I can access the old machine's disk drive just fine, but the still-cranky Windows XP system, the result of a desperate, last minute reinstall, will not let me successfully reinstall SQL Server 2005. Thus any consideration of a detach/reattach doesn't seem in the cards (if that's even what would be logical; I'm pretty confused about these things).

    This leaves me with the hope—perhaps naive—that I might try something like simply copying MSSQL.1, MSSQL.2 and MSSQL.3 from the old to the new. I think that's where all my data resides, as I never specified another location.

    Please, you wonderful experts, give me some suggestions?

    Thanks,

    Benn Gibson

  2. #2
    Join Date
    Mar 2007
    Posts
    1
    I had seen this situation before, what I did was reinstall SQL Server on this machine and attach the database, then move the database to another machine as usual way.

    vua

  3. #3
    Join Date
    Oct 2007
    Posts
    9
    Grab the the primary files (data and log) and reattach on new server
    All the IT jobs in one place - http://www.ITjobfeed.com

Similar Threads

  1. Replies: 4
    Last Post: 05-19-2006, 03:58 PM
  2. OBDC and SQL Server
    By angelia in forum Database
    Replies: 0
    Last Post: 07-01-2003, 03:42 PM
  3. Connect SQL Server Box to Oracle Box
    By Mark in forum Database
    Replies: 5
    Last Post: 07-15-2002, 10:24 AM
  4. SQL server vs Access
    By Samantha in forum Database
    Replies: 6
    Last Post: 01-25-2002, 02:15 PM
  5. Replies: 4
    Last Post: 05-17-2000, 12:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center