MS SQL Server 2005: what happens if the LDF file is lost?

Question

If I put the MS SQL log file on another drive and the drive fails.

What will happen to my MS SQL Database, will it create a new log file or how to fix it?

Answer 1

you need to restore / restore the database, see here: Restore database without ldf file