When I create a database in (for example) Drive E and Detach it and moving it to drive F and attached it gave me an error(Pic 4).When I copy it to Drive Windows(C),gave a message(Pic 2).
in Drive C I can Attach database success fully,but in this time the database was ReadOnly And I can't change any things of database(Pic 3).
when I change readonly from properties again give an error(Pic 5).
This link of Pictures
Please right click on the SSMS and then Run As Administrator (I know you are) but perfrom thosen operation again and see if you have any errors.
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
You might want to give provide explicit rights on the folder for the SQL Service account which stores the database files before attaching them. And do you get the same error when you execute the command sp_attach_db and try to attach the database. The following article talks about how permissions on the files differ if the account performing the detach of the database can be impersonated or not:
This posting is provided "AS IS" with no warranties, and confers no rights.
My Blog: http://troubleshootingsql.wordpress.com
SQL Server FAQ Blog on MSDN: http://blogs.msdn.com/sqlserverfaq