Msde 2000

Hi

I installed the MSDE that comes with Office 2000. When connecting to my mdf, I received an error saying that the header file is invalid. I understand that the MSDE shipped with Office 2000 uses the SQL 7 engine, therefore it does not recognize the my SQL 2000 database file format. Can someone tell me where can I get a copy of the correct version of MSDE that will work with my SQL 2000 mdf?

Thanks

SHKMSDE 2000 (http://www.microsoft.com/sql/msde/downloads/download.asp)|||Thank You

msdbdata.mdf missing after installing an instance of MSDE

Hi all,
msdbdata.mdf is missing after I install an instance of MSDE.
What could be causing this?
Thanks
hi Jason,
Jason Fischer wrote:
> Hi all,
> msdbdata.mdf is missing after I install an instance of MSDE.
> What could be causing this?
are you sure you correctly installed MSDE? no error has been reported? the
verbose log file shows no problems?
msdb database is a system database and is part of a proper installation...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
Yes, there was no error reported while installing.
I know that msdb is a system DB, that's what is bugging me.
I will check the log file again and see if there is anything funny reported
even though an error isn't logged.
Thanks,
Jason
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3kkk2oFuh3b0U1@.individual.net...
> hi Jason,
> Jason Fischer wrote:
> are you sure you correctly installed MSDE? no error has been reported? the
> verbose log file shows no problems?
> msdb database is a system database and is part of a proper installation...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

msdb(Suspect)

My Sql server msdb database demaged.
I did not backuped it before.
I copy the msdbdata.mdf and msdblog.ldf from other SQL database.
But not working.
How can I fix it
ThankHi Chen,
Search for << msdb database marked as "suspect" >> in this forum. And you
should be able to get the answer.
Also check this out: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33914
Thanks
GYK

msdb(Suspect)

My Sql server msdb database demaged.
I did not backuped it before.
I copy the msdbdata.mdf and msdblog.ldf from other SQL database.
But not working.
How can I fix it
Thank
Hi Chen,
Search for << msdb database marked as "suspect" >> in this forum. And you
should be able to get the answer.
Also check this out: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33914
Thanks
GYK

msdb(Suspect)

My Sql server msdb database demaged.
I did not backuped it before.
I copy the msdbdata.mdf and msdblog.ldf from other SQL database.
But not working.
How can I fix it
ThankHi Chen,
Search for << msdb database marked as "suspect" >> in this forum. And you
should be able to get the answer.
Also check this out: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33914
--
Thanks
GYK