• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

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.

0
jmatarranz
Asked:
jmatarranz
  • 3
1 Solution
 
RiteshShahCommented:
do you have write permission on the folder in which you have placed .MDF file?
0
 
RiteshShahCommented:
0
 
RiteshShahCommented:
this one is also useful but not better than previous one.

http://support.microsoft.com/kb/931640
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now