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
simon
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
|||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.[vbcol=seagreen]
>--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...
of[vbcol=seagreen]
add[vbcol=seagreen]
in.
>
>.
>
|||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...[vbcol=seagreen]
> 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.
> of
> add
> in.
|||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[vbcol=seagreen]
>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...
sort[vbcol=seagreen]
the[vbcol=seagreen]
file[vbcol=seagreen]
this[vbcol=seagreen]
manually
>
>.
>

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...
of[vbcol=seagreen]
add[vbcol=seagreen]
in.[vbcol=seagreen]
>
>.
>|||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...[vbcol=seagreen]
> 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.
> of
> add
> in.|||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...
sort[vbcol=seagreen]
the[vbcol=seagreen]
file[vbcol=seagreen]
this[vbcol=seagreen]
manually[vbcol=seagreen]
>
>.
>