sql server data warehouse: 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 -

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...
[quoted text, click to view]
question that I've been told to ask - someone may be able to answer, even if
the answer is "no".
[quoted text, click to view]
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.
[quoted text, click to view]
supports Post Alerts, Ratings, and Searching.

You don't have the ldf file anywhere?

-John Oakes

[quoted text, click to view]
question that I've been told to ask - someone may be able to answer, even if
the answer is "no".
[quoted text, click to view]
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.
[quoted text, click to view]
supports Post Alerts, Ratings, and Searching.