Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I copied a small database from one SQL Server 2008 R2 Express (physical) server to another of the same version, but I cannot re-attach. It attaches but the DB is greyed and read-only. It was writable in its former location.

share|improve this question
1  
How large is the db you are re-attaching? In my experience, until the database is "fully attached" it will be shown as read-only so larger database files may take a few moments. Also can you give some more detail on database server types, versions, storage/hardware specs, etc? –  Diffuser Oct 16 '13 at 21:14
    
+1 waiting for large files to come online properly is a good tip. –  Luke Puplett Oct 21 '13 at 9:14

1 Answer 1

up vote 0 down vote accepted

Ensure that the SQL Server account has permissions on the folder in which the database file(s) and log file(s) reside.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.