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
Showing posts with label attache. Show all posts
Showing posts with label attache. Show all posts
Wednesday, March 7, 2012
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/scripts/scriptdetails.asp?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
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/scripts/scriptdetails.asp?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
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/scr...sp?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
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/scr...sp?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
Subscribe to:
Posts (Atom)