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 |
|
UncleBob
Starting Member
2 Posts |
 Posted - 2006-09-22 : 05:04:31
|
| I'm running out of disk space on C: so I'm trying to move a DB to another local drive by detaching, copying the MDF and LDF files and then reattaching. When I reattach the DB is read-only.I seen this question asked many times and it looks as if the SA account doesn't have the required permissions to use the file on the other drive (only Microsoft know why!).I've tried giving everybody full control access to everything on this local drive but SA still can't use it? How can I make it so that SA can write to the database? |
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-09-22 : 12:34:46
|
| Did you check if SQL is Windows and SQL Authentication?.What OS do you have? Are you working with active directory? |
 |
|
|
UncleBob
Starting Member
2 Posts |
Posted - 2006-09-25 : 04:17:19
|
| I'm using Win2k and Windows and SQL Authentication. No active directory, it's just my local PC and I'm not even accessing the network for this. |
|
|
|
|
|
|
Reattaching and Read-only