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 |
|
thotvedt
Starting Member
5 Posts |
 Posted - 2011-01-21 : 12:52:52
|
| I moved database files using sp_detach_db and sp_attach_db, and the operation reported success. After the reattach the properties pages reported the files in the new location, but sp_helpfile still reports them in the old location and the database is in read-only mode. |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-21 : 14:52:02
|
| Check the file permissions on the mdf/ldf file and make sure they are not set to read only.Jeff |
 |
|
|
thotvedt
Starting Member
5 Posts |
Posted - 2011-01-24 : 11:03:13
|
| Turned out to be the permissions set on the service account. Thanks. |
|
|
|
|
|
|
DB in r/o mode after sp_attach