Groups | Blog | Home
all groups > sql server new users > march 2007 >

sql server new users : Attach database problem


Andrew J. Kelly
3/29/2007 4:09:58 PM
Did you detach the db first or simply copy the files? Was the db read only
before you detached it? I haven't worked that much with express so I can't
be of much more help than that but you may find these helpful for Express in
general. The sections about attaching might spark something as well.

http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express
with MSDE
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx
Backing up Express

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Gabriel
3/29/2007 9:03:37 PM
Hello,

I create a database on my development PC. I copy the 2 files on the computer
production, I'm trying to attach the database but I receive an error
......"can't be attach because the database is read-only"

DB created with SQLServer Express and the production is SQLServer Express
too

What can I do ?

Regards,

Andrew J. Kelly
3/30/2007 12:00:00 AM
There is no need to stop the service but did you ensure the db was not read
only before you detached it?

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Gabriel
3/30/2007 6:58:40 AM

[quoted text, click to view]

- Detach SQL DB
- Stop SQL Server service
- Copy the files

I did that few days ago and no problem, yesterday didn't work.

Regards,

AddThis Social Bookmark Button