Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to attach a database
Message
De
04/12/2006 12:43:19
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Titre:
How to attach a database
Divers
Thread ID:
01174651
Message ID:
01174651
Vues:
58
I deleted a database using the Window explorer. Then I ran Management Studio there was an entry for the disconnected Database I right clicked on the database and deleted the database from there too. It did deleted without any problem. Now when I copy the database into the folder where I deleted the database before and I run the Management Studio, attached the database it was attached but the Icon of the database is gray and in brackets says(Read-Only).
1-Why Read-Only.
2-When I right click on the database the system gets hang and i am unable to do anything.
3-What is the right way to attach the database?
The extension of the files are .MDF & .LDF.
I will be very thankful for you help:)
Répondre
Fil
Voir

Click here to load this message in the networking platform