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?
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.
Grab the the primary files (data and log) and reattach on new server
By software_develo in forum .NET
Last Post: 05-19-2006, 04:58 PM
By angelia in forum Database
Last Post: 07-01-2003, 04:42 PM
By Mark in forum Database
Last Post: 07-15-2002, 11:24 AM
By Samantha in forum Database
Last Post: 01-25-2002, 03:15 PM
By Greg Busby in forum Database
Last Post: 05-17-2000, 01:09 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL