| Groups | Blog | Home |
sql server msde : MSDE 2000
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,
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? [quoted text, click to view] "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? [quoted text, click to view] "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... > > 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 > >
hi Fred,
[quoted text, click to view] 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
hi Fred,
[quoted text, click to view] 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: [quoted text, click to view] >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
Andrea,
I am not sure of your question. What do you mean by have I been reported [quoted text, click to view] 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 [quoted text, click to view] "Andrea Montanari" wrote:
> 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 > >
Fred, have you found the answer????? I'm guessing after a couple of weeks
you have managed to sort it! Let us know. Phil [quoted text, click to view] "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
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |