Help with MSDE 1.0

Hi everyone!
First I'll expose my problem: I have a crashed disk which I believe had MSDE
1.0 installed (MSSQL7 folder). I had no problems recovering the databases
from backups but there was some DTS's that obviously were in msdb database.
I have the .mdf and .ldf files and I also have a backup but the problem is
that I can't find any disk with that version nor download from Internet, the
version is not available from microsoft downloads anymore. I tried to
recover it with MSDE 2 Release A, but if I try to upload the backup it says
that it was created with other version, and if I just overwrite the msf file
it goes to "suspect" state.
Now, I have two petitions :
1.- Can anybody point me to a place where I can download MSDE 1.0 o tell me
one software app has it included ?
2.- Does somebody know any workaround to recover this data using MSDE 2 Rel
A?
Thanks in advance
Eduardo Martinez O.
Chief of Information Systems
Industria Envasadora de Queretaro, S.A. de C.V.
hi Eduardo,
"Eduardo Martinez" <eduardom@.nospamieqsa.com.mx> ha scritto nel
messaggio news:OCyWNNV2EHA.1192@.tk2msftngp13.phx.gbl
> Hi everyone!
> First I'll expose my problem: I have a crashed disk which I believe
> had MSDE
> 1.0 installed (MSSQL7 folder). I had no problems recovering the
> databases from backups but there was some DTS's that obviously were
> in msdb database. I have the .mdf and .ldf files and I also have a
> backup but the problem is that I can't find any disk with that
> version nor download from Internet, the version is not available from
> microsoft downloads anymore. I tried to recover it with MSDE 2
> Release A, but if I try to upload the backup it says that it was
> created with other version, and if I just overwrite the msf file it
> goes to "suspect" state.
> Now, I have two petitions :
> 1.- Can anybody point me to a place where I can download MSDE 1.0 o
> tell me one software app has it included ?
> 2.- Does somebody know any workaround to recover this data using MSDE
> 2 Rel A?
>
1) don't know how much legal...
http://www.blackberry.net/support/downloads/msde.shtml ... I do think (some
or all) Office 2000 (editions) should contain MSDE 1.0 too...
2) unfortunately not, as msdb database of 7.0 code base can not be restored
on 2000 versions...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks a lot, I downloaded from the page you told. I'll just use it to
restore mi backup and send the dts to the new disk.
Eduardo Martinez O.