MSDE 2000

Hello!!
I have a application that creates an instance of MSDE 2000 called
MMSQL$EMMSDE. It uses its own login to pass inforamtion called embuser. This
company does not provide information on how to recover data from the
database. I have a client that had their motherboard crash and needed a new
computer and wanted to recover the data off the drive. I have the MDF and LDF
files all under the data folder. Everytime I copy these over to a new
installation says that it is no good and my aplication I use cannot connect
to it as well. Is there anyway that anybody knows of on how to reconnect the
MDF file to another computer that has a fresh install of this applciation and
instance so it can receover the data?
Any and all posts is appreciated.
Thanks,
Fred
After you copied the MDF and/or LDF files to the new computer, where an SQL
Server/MSDE is installed, did you attached the data file the the instance of
SQL Server/MSDE?
"Fred Boltz" <Fred Boltz@.discussions.microsoft.com> wrote in message
news:57576684-C93B-4BD3-AF85-6A03BB605A8D@.microsoft.com...
> Hello!!
> I have a application that creates an instance of MSDE 2000 called
> MMSQL$EMMSDE. It uses its own login to pass inforamtion called embuser.
> This
> company does not provide information on how to recover data from the
> database. I have a client that had their motherboard crash and needed a
> new
> computer and wanted to recover the data off the drive. I have the MDF and
> LDF
> files all under the data folder. Everytime I copy these over to a new
> installation says that it is no good and my aplication I use cannot
> connect
> to it as well. Is there anyway that anybody knows of on how to reconnect
> the
> MDF file to another computer that has a fresh install of this applciation
> and
> instance so it can receover the data?
> Any and all posts is appreciated.
> Thanks,
> Fred
|||I tried using a 3rd party software to attach the file but could not. Can you
tell me how to go about doing that?
"Norman Yuan" wrote:

> After you copied the MDF and/or LDF files to the new computer, where an SQL
> Server/MSDE is installed, did you attached the data file the the instance of
> SQL Server/MSDE?
>
> "Fred Boltz" <Fred Boltz@.discussions.microsoft.com> wrote in message
> news:57576684-C93B-4BD3-AF85-6A03BB605A8D@.microsoft.com...
>
>
|||hi Fred,
Fred Boltz wrote:
> I tried using a 3rd party software to attach the file but could not.
> Can you tell me how to go about doing that?
>
have you been reported with an exception? what is the message?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Andrea,
I am not sure of your question. What do you mean by have I been reported
with an exception? Here was the original message I wrote:
Hello!!
I have a application that creates an instance of MSDE 2000 called
MMSQL$EMMSDE. It uses its own login to pass inforamtion called embuser. This
company does not provide information on how to recover data from the
database. I have a client that had their motherboard crash and needed a new
computer and wanted to recover the data off the drive. I have the MDF and LDF
files all under the data folder. Everytime I copy these over to a new
installation says that it is no good and my aplication I use cannot connect
to it as well. Is there anyway that anybody knows of on how to reconnect the
MDF file to another computer that has a fresh install of this applciation and
instance so it can receover the data?
Any and all posts is appreciated.
Thanks,
Fred
"Andrea Montanari" wrote:

> hi Fred,
> Fred Boltz wrote:
> have you been reported with an exception? what is the message?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||hi Fred,
Fred Boltz wrote:
> Andrea,
> I am not sure of your question. What do you mean by have I been
> reported with an exception? Here was the original message I wrote:
you answered to Norman:
>I tried using a 3rd party software to attach the file but could not. Can
>you
>tell me how to go about doing that?
did the tool you used to re-attach the database reported you an exception?
anyway, you can use oSql.exe, the command line tool provided with MSDE to
reattach the database..
you have to log in as a sysadmin member so to have admin permissions granted
in MSDE using a truste connection, or you have to provide credentials of a
standard SQL Server login member of the sysadmin SQL Server group (like
"sa")..
once you are connected, you have to execute the sp_attach_db
(http://msdn2.microsoft.com/en-us/library/aa259611(SQL.80).aspx) system
stored procedure like
1>EXECUTE master..sp_attach_db @.dbname = 'the_database_name',
2>@.filename1 = N'ful_path_to_the_mdf_file.Mdf',
3>@.filename2 = N'ful_path_to_the_ldf_file.Ldf'
4>GO
then you can quit oSql.exe.. see
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003 for further
info about oSql.ex and MSDE uses
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply