I'm trying to attach a MDF file with no LOG (log file has been deleted). Normally SQLServer creates a new LOG file. But this time I get this message:
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'FCT_ENTIDADES'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\FCT_ENTIDADES_Log.LDF' may be incorrect.
There is no FCT_ENTIDADES_Log.LDF in the Data directory.
Can someone give me a hand on this?