Tuesday, March 27, 2012

Exporting MSDE database from one installation to another

I have two hard drives, one contains a previous installation of MSDE and a
non-bootable OS and there is a database on that installation that I need to
import to my new MSDE instance on the new hard drive. Is there an easy way
to do this?
Hi,
Since OS is non bootable , there is no chance to detach or to do a backup
all databases. Only option is:-
1. Copy all .MDF and .LDF files to a new folder (safe location)
2. Install SQL server and same Service packs (as old) in the identical
folder (Same as old installation)
3. Stop the new MSDE
4. Copy the .MDF and .LDF files (took in step 1) to the same folders (Same
as old installation).
5. Start MSDE
Now login to query analyzer or enterprise manager and confirm all the
databases are online.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:81E57616-2B2F-4426-AD58-4CE39EAA78D1@.microsoft.com...
> I have two hard drives, one contains a previous installation of MSDE and a
> non-bootable OS and there is a database on that installation that I need
to
> import to my new MSDE instance on the new hard drive. Is there an easy
way
> to do this?
sql

No comments:

Post a Comment