attach

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.

jmatarranzAsked:
Who is Participating?
 
RiteshShahCommented:
this one is also useful but not better than previous one.

http://support.microsoft.com/kb/931640
0
 
RiteshShahCommented:
do you have write permission on the folder in which you have placed .MDF file?
0
 
RiteshShahCommented:
0
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.