General information
Forum:
Microsoft SQL Server
Title:
How to attach a database
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:)
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only