Recovering data from a mdf file

Hi,
This is a very long shot. I'm not an sql expert by any means but I have a question that I've been told to ask - someone may be able to answer, even if the answer is "no".
A sql table has been emptied of all rows. There is no backup of the .mdf prior to this happening. No transaction logging is in place. The server on which the .mdf resides has not been re-booted since the table was emptied. The .mdf has not been re-organis
ed.
Is there any way that the data from that table can be recovered? Does it still physically exist in the .mdf, albeit in a marked for deletion form?
Thanks & regards,
Paul
Paul Burton
Manchester,
England
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
From my point of view the answer is: no
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> a crit dans le message de
news:uNUw4LuTEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Hi,
> This is a very long shot. I'm not an sql expert by any means but I have a
question that I've been told to ask - someone may be able to answer, even if
the answer is "no".
> A sql table has been emptied of all rows. There is no backup of the .mdf
prior to this happening. No transaction logging is in place. The server on
which the .mdf resides has not been re-booted since the table was emptied.
The .mdf has not been re-organised.
> Is there any way that the data from that table can be recovered? Does it
still physically exist in the .mdf, albeit in a marked for deletion form?
> Thanks & regards,
> Paul
> Paul Burton
> Manchester,
> England
>
>
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||You don't have the ldf file anywhere?
-John Oakes
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uNUw4LuTEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Hi,
> This is a very long shot. I'm not an sql expert by any means but I have a
question that I've been told to ask - someone may be able to answer, even if
the answer is "no".
> A sql table has been emptied of all rows. There is no backup of the .mdf
prior to this happening. No transaction logging is in place. The server on
which the .mdf resides has not been re-booted since the table was emptied.
The .mdf has not been re-organised.
> Is there any way that the data from that table can be recovered? Does it
still physically exist in the .mdf, albeit in a marked for deletion form?
> Thanks & regards,
> Paul
> Paul Burton
> Manchester,
> England
>
>
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
sql