No backup

Hi,
Is there any way of restoring a MSSQL 2000 database if there has been
no backup?
Possibly from the log files?
Thanks.Perhaps sp_detach_db, sp_attach_db?
<gdf1903@.hotmail.com> wrote in message
news:1146055288.324722.292320@.i40g2000cwc.googlegroups.com...
> Hi,
> Is there any way of restoring a MSSQL 2000 database if there has been
> no backup?
> Possibly from the log files?
> Thanks.
>|||What do you want to achieve by such a "restore"? Is the database gone (delet
ed)? Have you discovered
some physical corruption in the database? Do you wish to go back in time?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<gdf1903@.hotmail.com> wrote in message news:1146055288.324722.292320@.i40g2000cwc.googlegroup
s.com...
> Hi,
> Is there any way of restoring a MSSQL 2000 database if there has been
> no backup?
> Possibly from the log files?
> Thanks.
>|||I wish to revert back to a previous time. Around 8 hours ago.|||I wish to revert back to a previous time. Around 8 hours ago.|||gdf1903@.hotmail.com wrote:
> I wish to revert back to a previous time. Around 8 hours ago.
>
That will not be possible unless you have a full backup that are more
than 8 hours old to start with.
Regards
Steen|||You are probably out of luck. You could see if any of the log reader tools c
an extract log records
from the ldf file for you. But the log records might not exist anymore in th
e ldf file. They will
most probably not exist if you never done a database backup or if the databa
se is in simple recovery
mode (as SQL Server will remove old log records in these cases every time it
does a checkpoint).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<gdf1903@.hotmail.com> wrote in message news:1146060959.519582.169180@.u72g2000cwu.googlegroup
s.com...
>I wish to revert back to a previous time. Around 8 hours ago.
>