Read MDF

is there any way of opening an MDf file into some sort of
readable format? we had our server crash on us and the
backup/ restore is not working. I only have the mdf file
for the database and was wondering if i could get this
into some sort of formatting i could open and manually add
our old database back in as it only had a few details in.
thanks
simonHi
No. Have you tried sp_attach_single_file_db?
Failing that, phone MS PSS.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Simon" <simon@.talktalk.net> wrote in message
news:13d001c515ac$a8337530$a401280a@.phx.gbl...
> is there any way of opening an MDf file into some sort of
> readable format? we had our server crash on us and the
> backup/ restore is not working. I only have the mdf file
> for the database and was wondering if i could get this
> into some sort of formatting i could open and manually add
> our old database back in as it only had a few details in.
> thanks
> simon|||thanks mike, i have tried sp_attach_single_file_db but
without joy.
we have had to reinstall the OS and SQL and this was the
only file we had a good copy of.
i will try Ms PSS thanks.
>--Original Message--
>Hi
>No. Have you tried sp_attach_single_file_db?
>Failing that, phone MS PSS.
>Regards
>--
>Mike Epprecht, Microsoft SQL Server MVP
>Zurich, Switzerland
>IM: mike@.epprecht.net
>MVP Program: http://www.microsoft.com/mvp
>Blog: http://www.msmvps.com/epprecht/
>"Simon" <simon@.talktalk.net> wrote in message
>news:13d001c515ac$a8337530$a401280a@.phx.gbl...
>> is there any way of opening an MDf file into some sort
of
>> readable format? we had our server crash on us and the
>> backup/ restore is not working. I only have the mdf file
>> for the database and was wondering if i could get this
>> into some sort of formatting i could open and manually
add
>> our old database back in as it only had a few details
in.
>> thanks
>> simon
>
>.
>|||Just out of curiosity, what problem do you encounter when you try to
re-attach the MDF? The following article explains other issues related to
restoring a DB on another server install:
http://support.microsoft.com/kb/314546#10
<anonymous@.discussions.microsoft.com> wrote in message
news:13f201c515b2$0691fd40$a401280a@.phx.gbl...
> thanks mike, i have tried sp_attach_single_file_db but
> without joy.
> we have had to reinstall the OS and SQL and this was the
> only file we had a good copy of.
> i will try Ms PSS thanks.
> >--Original Message--
> >Hi
> >
> >No. Have you tried sp_attach_single_file_db?
> >Failing that, phone MS PSS.
> >
> >Regards
> >--
> >Mike Epprecht, Microsoft SQL Server MVP
> >Zurich, Switzerland
> >
> >IM: mike@.epprecht.net
> >
> >MVP Program: http://www.microsoft.com/mvp
> >
> >Blog: http://www.msmvps.com/epprecht/
> >
> >"Simon" <simon@.talktalk.net> wrote in message
> >news:13d001c515ac$a8337530$a401280a@.phx.gbl...
> >> is there any way of opening an MDf file into some sort
> of
> >> readable format? we had our server crash on us and the
> >> backup/ restore is not working. I only have the mdf file
> >> for the database and was wondering if i could get this
> >> into some sort of formatting i could open and manually
> add
> >> our old database back in as it only had a few details
> in.
> >>
> >> thanks
> >>
> >> simon
> >
> >
> >.
> >|||Hi Johnny
An sp_attach_single_file_db is only guarenteed to work is
an sp_detach_db is used, otherwise its a bit of a lottery
whether it works or not.
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts_sp_ae-az_4wrm.asp
Peter
"I may be drunk, Miss, but in the morning I will be sober
and you will still be ugly."
Winston Churchill
>--Original Message--
>Just out of curiosity, what problem do you encounter when
you try to
>re-attach the MDF? The following article explains other
issues related to
>restoring a DB on another server install:
>http://support.microsoft.com/kb/314546#10
><anonymous@.discussions.microsoft.com> wrote in message
>news:13f201c515b2$0691fd40$a401280a@.phx.gbl...
>> thanks mike, i have tried sp_attach_single_file_db but
>> without joy.
>> we have had to reinstall the OS and SQL and this was the
>> only file we had a good copy of.
>> i will try Ms PSS thanks.
>> >--Original Message--
>> >Hi
>> >
>> >No. Have you tried sp_attach_single_file_db?
>> >Failing that, phone MS PSS.
>> >
>> >Regards
>> >--
>> >Mike Epprecht, Microsoft SQL Server MVP
>> >Zurich, Switzerland
>> >
>> >IM: mike@.epprecht.net
>> >
>> >MVP Program: http://www.microsoft.com/mvp
>> >
>> >Blog: http://www.msmvps.com/epprecht/
>> >
>> >"Simon" <simon@.talktalk.net> wrote in message
>> >news:13d001c515ac$a8337530$a401280a@.phx.gbl...
>> >> is there any way of opening an MDf file into some
sort
>> of
>> >> readable format? we had our server crash on us and
the
>> >> backup/ restore is not working. I only have the mdf
file
>> >> for the database and was wondering if i could get
this
>> >> into some sort of formatting i could open and
manually
>> add
>> >> our old database back in as it only had a few details
>> in.
>> >>
>> >> thanks
>> >>
>> >> simon
>> >
>> >
>> >.
>> >
>
>.
>