Showing posts with label readonly. Show all posts
Showing posts with label readonly. Show all posts

Friday, March 23, 2012

remotely attached DB ends up readonly .. why oh why oh why ..

I have what seems like a commonish problem.
I have copied my database (mdf and logfile) to a remote XP desktop machine
... when using SQL server managment express tool when I try to attach the
DB it ends up readonly.
The file permissions are not set to read only (a problem I have read)
And I've done this shrink-detach-transfer-attach with various versions of
this database at least 20 times in the last week.
But not now it would seem.
The strange thing is that if I drop this database into the sql server default
'data' directory it works fine.
This doesnt explain why the second database that sits in the original 'destination'
directory attaches just fine.
I am utterly confused - traps for new players I guess.
---
[Sam Samson] - There is no greater folly than fixed price quoting.Sam
On the source machine, did you issue sp_detach the database? Take a look at
ALTER DATABASE... SET READ_WRITE option if I remember well
"Sam Samson" <nospamsam@.nospam.com.au> wrote in message
news:ece03a7894c38c9b916d29dee90@.news.microsoft.com...
>I have what seems like a commonish problem.
> I have copied my database (mdf and logfile) to a remote XP desktop machine
> ... when using SQL server managment express tool when I try to attach the
> DB it ends up readonly.
> The file permissions are not set to read only (a problem I have read) And
> I've done this shrink-detach-transfer-attach with various versions of this
> database at least 20 times in the last week.
> But not now it would seem.
> The strange thing is that if I drop this database into the sql server
> default 'data' directory it works fine.
> This doesnt explain why the second database that sits in the original
> 'destination' directory attaches just fine.
> I am utterly confused - traps for new players I guess.
> ---
> [Sam Samson] - There is no greater folly than fixed price quoting.
>
>