Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL2008 RC won't attach 2005 mdf - sees it as read only
Message
 
 
À
23/06/2008 00:03:04
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01326060
Message ID:
01326085
Vues:
16
Charles,

Try Alter database set read_write. See http://bhaidar.net/cs/archive/2007/05/24/sql-server-express-and-read-only-databases.aspx
If it doesn't work then it's access rights issue.

>New Vista Ultimate box. Clean install of latest SQL 2008 RC. Then installed VS 2008 and SQL Express2005.
>
>From my XP box I detached two databases from an instance of SQL Express 2005. Copied the mdf and log files to the data folders of the two SQLs on the Vista box.
>
>SQL 2008 MS will attach the databases to the SQL Express 2005 server, but sees them as read only. I can then change them to readable. OK. Never saw that on XP boxes but ok.
>
>But the SQL 2008 will not allow the attach, saying the databases are read only or contain files that are read only.
>
>Both databases re-attach on the xp sql 2005 box with no problem.
>
>I assume I need to attach the database in 2008 with a T-sql CREATE DATABASE ... TO ATTACH TRUSTWORTHY ON but can't seem to get the syntax right.
>
>Guidance appreciated.
>
>TIA
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform