Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_pioneer
Starting Member
3 Posts |
 Posted - 2007-11-30 : 20:49:42
|
After I reinstalled SQL Server 2000, I attached the existing database files (.mdf and .ldf). The database is now online in read only mode. I tried to modify the properties to take the database out of read only mode, but I got an error saying that the .mdf file may not exist. I know it exists because I can read all of the data in the database. I even checked to make sure that the .mdf and .ldf files were not in read only mode. Any suggestions? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 01:39:04
|
| Query sysfiles to see if db files are in correct path. |
 |
|
|
sql_pioneer
Starting Member
3 Posts |
Posted - 2007-12-02 : 19:08:58
|
| I queried sysfiles and verified that the files are in the correct path. I'm at a loss here |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 22:49:09
|
| Any related messages in sql server log? Do you have db backup by the way? |
|
|
|
sql_pioneer
Starting Member
3 Posts |
Posted - 2007-12-03 : 01:42:29
|
| I ended up loading a back up. I lost a few days of data, but not too big of a deal. |
|
|
|
craig79
Starting Member
33 Posts |
Posted - 2007-12-05 : 00:09:02
|
| Please check your .mdf & .ldf (I mean in the windows explorer).If their properties shows Read Only please unmark it.After both are brought back to Read_write ,then try attaching the Database. |
|
|
|
|
|
|
Database Stuck in Read Only Mode