Hello experts

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.

Who is Participating?
this one is also useful but not better than previous one.
do you have write permission on the folder in which you have placed .MDF file?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.