Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Trying to attach SQL Server databases: database cannot be upgraded because it is read-only or has read-only files

Posted on 2011-02-18
6
Medium Priority
?
1,927 Views
Last Modified: 2012-08-13
Hello,

I took a copy of mdf and ldf files from SQL Express 2008 instance. SQL Service was in stopped mode. Now I'm trying to attach them to SQL Server 2008 Enterprise Instance. I get error message: database cannot be upgraded because it is read-only or has read-only files.

I have checked file properties and there is not read only checkbox checked. How I should go forward to get these DBs to be attached. I dont have access to this 2008 Express instance anymore (it's in different city and I should make this change during weekend).

Any help is appreciated
0
Comment
Question by:thaapavuori
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 

Author Comment

by:thaapavuori
ID: 34930230
I forget the pics
sql.png
sql2.png
0
 
LVL 12

Expert Comment

by:mcv22
ID: 34930272
0
 

Author Comment

by:thaapavuori
ID: 34930362
My SQL service is running on local system account. My local system account has full controll to these files. I also tried to change SQL service to run on my admin account but same results... Still looking solution...
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:thaapavuori
ID: 34930380
I have copied my MDF and LDF files to SQL default data directory (in my case E:\Program Files\Microsoft SQL Server\MSSQL10.INSTANCENAME\MSSQL\DATA). When I try to attach them I get that error.

I just tried to copy one mdf and ldf file to c:\temp folder. From there I was able to attach databases. So this has something to do with permissions but I dont really understand where is the mistake.
0
 
LVL 12

Accepted Solution

by:
mcv22 earned 2000 total points
ID: 34930391
Under security options, give full control to the SQL Service login to the E:\Program Files\Microsoft SQL Server\MSSQL10.INSTANCENAME folder and any sub-folders.
0
 

Author Comment

by:thaapavuori
ID: 34930493
Thanks. It was because of UAC. I was opened SQL manager with windows authentication. Because of UAC my domain admin account couldnt use these admin level rights. I didnt finally change my folder security settings. I just basically logged in to SQL manager wih SA credentials and I was able to attach my DBs.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question