Restore Database

[abo el ror]

If a database is dettached and its log file (.ldf) has been deleted, I am trying to attach this database again , but i am facing some problems. Do someone have a solution for me ?

[Michael Potter]

The command is sp_attach_db. Example: EXEC sp_attach_db @dbname = N'pubs', @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf' I prefer using a backup/restore approach.

[Anonymous]

Thank you my friend, but my problem is that the Log.ldf file is not found (deleted), so @filename2 is invalid. Do you have another way ?