I have a SQL Server 2005
I was suspended in a database and only have the file and run the following t04_historical_data.mdf ence to recreate the log file. Executo the following sequence:
Sp_attach_single_file_db exec @ dbname = 't04_historical', @ physname = 'e: \ tango04Data \ t04_historical_Data.MDF'
and the result is:
Msg 3415, Level 16, State 3, Line 1
Database 't04_historical' can not be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 't04_historical. CREATE DATABASE is aborted.