Moving MSDE Data Files to another PC

  • Thread starter Thread starter TSP
  • Start date Start date
T

TSP

I'm fairly new to using ACCESS 2000 with MSDE on just a
LOCAL machine. Recently had a hardware failure and had to
move everything to a new PC. The hard drive on the old
was still intact. I reloaded OFFICE and MSDE from scratch
on the new PC and installed the old hard drive as
secondary and used explorer to copy the MDF/LDF files into
the DATA MSSQL directory. When I try to use those data
files MSDE can't seem to find them or doesn't recognize
them. Do these files need to be copied into MSDE in some
other way, can you not move SQL databases between
different instances of MSDE? I'm kind of stumped and
REALLY don't want to lose everything on those files. Is
there some procedure I'm not following. Any ideas ????
 
Create a new database with the same name and then copy the backup data files
onto the ones just created.

HTH,

Brian Bischof

A Crystal Reports.NET book for programmers? Its free!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented

http://www.123aspx.com/redir.aspx?res=30160
 
An alternate method is to "detach" the database on the source PC, copy the
actual .mdf and .ldf files to the target PC, then "attach" the database on
the target PC. It accomplishes the same thing as backup and restore, but
detach and attach take less time than backup and restore. There is a lot of
documentation out there on how to do this. Start by going to
search.microsoft.com and searching on "detach database" and "attach
database"

--
Kent T. Stuver, President
Nanjimi Group, Inc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Stop Money Worries NOW!!
Reduce your debt, create excess cash for
investing, and build an ongoing, passive income.
Click NOW==> http://www.controlyourcashflow.com/2/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
Thanks Brian for suggesting copying the database. That
idea sent me down the path of doing the DETACH and ATTACH
that Kent subsequently suggested when SQL7 would not let
me copy over one of it's files without the DETACH.

I ran the DETACH and ATTACH SP's from the 'masterdb'. It
worked fine but I wasn't sure if there was a better way.

I have my files back and functional.

I'm new but learning more about this beast every day with
your help.

Thanks Brian and Kent for your help !!!!
 
Back
Top