How to recover a SQL Server database after a crash

Hi,
I had my Windows 2000 crashed and after that I reinstalled windows, sql
server etc. after taking backup of all mdf ( and no ldfs by mistake).
Now when I try to restore it, it says,
--
Could not open new database 'kothari1'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'D:\Program Files\Microsoft
SQL Server\MSSQL\data\Kothari_log.LDF' may be incorrect.
--
Any help please - I do not have ANY backup of this database :(
Thanks
AmitSee if you can use
sp_attach_db OR
sp_attach_single_file_db
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Amit Basu" <amit@.winruler.com> wrote in message
news:OHKSpDSRDHA.3768@.tk2msftngp13.phx.gbl...
> Hi,
> I had my Windows 2000 crashed and after that I reinstalled windows, sql
> server etc. after taking backup of all mdf ( and no ldfs by mistake).
> Now when I try to restore it, it says,
> --
> Could not open new database 'kothari1'. CREATE DATABASE is aborted.
> Device activation error. The physical file name 'D:\Program
Files\Microsoft
> SQL Server\MSSQL\data\Kothari_log.LDF' may be incorrect.
> --
> Any help please - I do not have ANY backup of this database :(
> Thanks
> Amit
>

How to reapply a trasaction log to a database?

Hi everybody,

I'm in a very awfull situation. Because of a big crash in my MS Sql server, y loose the .mdf file of a database. I have an older .mdf file and the complete transaction log (.ldf file) before the crash. [Note: not a backup file, just the .ldf file]. As far as I know, no truncate has been performed since the date of the mdf file, therefore, all transaction shoud be "stored" inside the log file.

Is there any way to re-apply the transactions stored on the log file to the original database?

I will appreciate a lot any help.

Thanks in advance,

Enrique.

enrique_pinaud@.hotmail.com

I don′t know if there is a a thrid party tool, but restoring for Point in time recovery (like you need) is only supported with builtin tools with a backup.

HTH, jens Suessmeyer.|||Without a backup to start from you won't be able to use any builtin mechanisms to recover with only an old mdf and the current ldf. There are 3rd party tools out there that can extract dml statements out of the log, and may be of some help to you.