MS SQL 2k db and damaged log file

Hi ALL,
I would like to attache my data base but I have damaged log file. Could
some one explain how to play with such a DB ? Does anyone know howto dump
data from *.mdb file without MS SQL 2k server ?
Regards,
Fibre Optic
..mdb is a MS Access file. Did you mean mdf?
I can't help to notice the similarity in your problem with another post that
was made recently... In addition to having a similar problem you both have
fictional names.
The other post:
Homer J. Simpson <root@.127.0.0.1>
Can't attach to database...
Monday, March 21, 2005 8:19 AM
microsoft.public.sqlserver.newusers
Keith
"Fibre Optic" <fibre_optic@.go2.pl> wrote in message
news:d1rovc$5gg$1@.inews.gazeta.pl...
> Hi ALL,
> I would like to attache my data base but I have damaged log file. Could
> some one explain how to play with such a DB ? Does anyone know howto dump
> data from *.mdb file without MS SQL 2k server ?
> Regards,
> Fibre Optic
>
|||I would try using sp_attach_single_file_db first and if that doesn't work
then have a look here:
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
Andrew J. Kelly SQL MVP
"Fibre Optic" <fibre_optic@.go2.pl> wrote in message
news:d1rovc$5gg$1@.inews.gazeta.pl...
> Hi ALL,
> I would like to attache my data base but I have damaged log file. Could
> some one explain how to play with such a DB ? Does anyone know howto dump
> data from *.mdb file without MS SQL 2k server ?
> Regards,
> Fibre Optic
>
|||Fibre
Detach the database and remove the log file. Then attach the database with
single file (for more details please refer to the BOL)
"Fibre Optic" <fibre_optic@.go2.pl> wrote in message
news:d1rovc$5gg$1@.inews.gazeta.pl...
> Hi ALL,
> I would like to attache my data base but I have damaged log file. Could
> some one explain how to play with such a DB ? Does anyone know howto dump
> data from *.mdb file without MS SQL 2k server ?
> Regards,
> Fibre Optic
>
|||answer inline
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uGOFrr6LFHA.3788@.tk2msftngp13.phx.gbl...
> Fibre
> Detach the database and remove the log file. Then attach the database with
> single file (for more details please refer to the BOL)
>
The DB is deattached and I can not attache the db due to damage of log
file. I found such a useful soft:
http://officerecovery.com/mssql/?submit#express
Thanks a lot for ALL answers !!!
Regards,
Fibre Optic