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 (deleted)? 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.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.
>|||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 can extract log records
from the ldf file for you. But the log records might not exist anymore in the ldf file. They will
most probably not exist if you never done a database backup or if the database 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.googlegroups.com...
>I wish to revert back to a previous time. Around 8 hours ago.
>