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.
>
>
Friday, March 23, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment