Disaster : Getting data from LDF files into new SQL Server

I have had a bit of a disaster with our SQL server, and its temporarily
dead. I will reinstall from scratch but I have another SQL server on our
SBS server that I would like to use in the meantime. Can I import or
regsiter those files on the dead server into a database on the SBS sql
server?If you have all the files that constitutes the database (mdf, possibly ndf a
nd ldf), you can try sp_attach_db.
Attach is only guaranteed to work if you cleanly detached the database first
, however. It might work even if
you didn't. If it doesn't work, you need to do a restore from a backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Child" <dawg@.alaskaSPAMFREE.com> wrote in message news:10ia37qkv0g41db@.corp.supernews.com..
.
> I have had a bit of a disaster with our SQL server, and its temporarily
> dead. I will reinstall from scratch but I have another SQL server on our
> SBS server that I would like to use in the meantime. Can I import or
> regsiter those files on the dead server into a database on the SBS sql
> server?
>