How to recover a SQL Server database after a crash

[Amit Basu]

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

[Allan Mitchell]

See if you can use

sp_attach_db OR
sp_attach_single_file_db

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
[url]www.SQLDTS.com[/url]
I support PASS - the definitive, global community
for SQL Server professionals - [url]http://www.sqlpass.org[/url]

"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
>
>

[zlatan24]

Couple days ago I was at the I-net and perceived there an unusual tool, which to my great surprise aided me quite easy. But it moreover the application showed me some interesting features - how to recover sql database.

[lapwlover]

I prefer to choose one reliable tool to backup database. Like easeus todo backup advanced server. Database is so important. I don't want to be trapped in the trouble when them crash.