moving a database causes it to be read-only

Using SS2000 SP4. I've done this many times before without problem so I don'
t
know why I'm having trouble this time. I'm running out of space on a drive s
o
I'm moving some databases to another drive. I've tried this with EM and QA
using this query:
EXEC sp_detach_db 'jg', 'false'
EXEC sp_attach_db @.dbname = 'jg',
@.filename1 = 'S:\SQL\Data\jg_Data.mdf',
@.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
After attaching the database, the database comes up read-only. Can someone
tell me why?
Thanks,
--
Dan D.Hi Dan
"Dan D." wrote:

> Using SS2000 SP4. I've done this many times before without problem so I do
n't
> know why I'm having trouble this time. I'm running out of space on a drive
so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.
Do you get an error when you try to make them not read-only?
Have you checked the readonly attribute on these files? To uncheck them you
will need to detach the database again.
How did you move the files?
John|||I didn't get an error. I did this twice on two different databases and had
the same problem both times. I didn't check the readonly attribute but since
I moved the files using drag-and-drop, I wouldn't expect the attribute to
change.
I had a backup of the database and I restored it and didn't have any problem
.
Thanks,
--
Dan D.
"John Bell" wrote:

> Hi Dan
> "Dan D." wrote:
>
> Do you get an error when you try to make them not read-only?
> Have you checked the readonly attribute on these files? To uncheck them yo
u
> will need to detach the database again.
> How did you move the files?
> John|||Hi Dan
"Dan D." wrote:

> I didn't get an error. I did this twice on two different databases and had
> the same problem both times. I didn't check the readonly attribute but sin
ce
> I moved the files using drag-and-drop, I wouldn't expect the attribute to
> change.
> I had a backup of the database and I restored it and didn't have any probl
em.
> Thanks,
> --
> Dan D.
If you didn't get an error changing the database from readonly the file
attributes must be ok. I did find this
http://forums.microsoft.com/MSDN/Sh...303056&SiteID=1 where
the service accounts permissions on the directory has an impact, so it may b
e
your permissions rather than the service accounts if you backup/restore work
s
ok.
John
John|||Hi,
I know that in SQL 2005 when attaching databases they come up in a state of
reduced functinality. This is a security measure to make sure that someone
cannot attach a database that gives them more permsissions than they might
otherwise have. Maybe some of this concept made it into SQL2000 SP4.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:5F9EE66C-31AC-4AC6-A971-7613346DBE1D@.microsoft.com...
> Using SS2000 SP4. I've done this many times before without problem so I
> don't
> know why I'm having trouble this time. I'm running out of space on a drive
> so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.|||It was the security on the folder that I was moving the data to. The user
didn't have enough permissions.
Thanks,
--
Dan D.
"John Bell" wrote:

> Hi Dan
> "Dan D." wrote:
>
> If you didn't get an error changing the database from readonly the file
> attributes must be ok. I did find this
> http://forums.microsoft.com/MSDN/Sh...303056&SiteID=1 wher
e
> the service accounts permissions on the directory has an impact, so it may
be
> your permissions rather than the service accounts if you backup/restore wo
rks
> ok.
> John
> John

moving a database causes it to be read-only

Using SS2000 SP4. I've done this many times before without problem so I don't
know why I'm having trouble this time. I'm running out of space on a drive so
I'm moving some databases to another drive. I've tried this with EM and QA
using this query:
EXEC sp_detach_db 'jg', 'false'
EXEC sp_attach_db @.dbname = 'jg',
@.filename1 = 'S:\SQL\Data\jg_Data.mdf',
@.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
After attaching the database, the database comes up read-only. Can someone
tell me why?
Thanks,
--
Dan D.Hi Dan
"Dan D." wrote:
> Using SS2000 SP4. I've done this many times before without problem so I don't
> know why I'm having trouble this time. I'm running out of space on a drive so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.
Do you get an error when you try to make them not read-only?
Have you checked the readonly attribute on these files? To uncheck them you
will need to detach the database again.
How did you move the files?
John|||I didn't get an error. I did this twice on two different databases and had
the same problem both times. I didn't check the readonly attribute but since
I moved the files using drag-and-drop, I wouldn't expect the attribute to
change.
I had a backup of the database and I restored it and didn't have any problem.
Thanks,
--
Dan D.
"John Bell" wrote:
> Hi Dan
> "Dan D." wrote:
> > Using SS2000 SP4. I've done this many times before without problem so I don't
> > know why I'm having trouble this time. I'm running out of space on a drive so
> > I'm moving some databases to another drive. I've tried this with EM and QA
> > using this query:
> > EXEC sp_detach_db 'jg', 'false'
> > EXEC sp_attach_db @.dbname = 'jg',
> > @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> > @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> >
> > After attaching the database, the database comes up read-only. Can someone
> > tell me why?
> >
> > Thanks,
> > --
> > Dan D.
> Do you get an error when you try to make them not read-only?
> Have you checked the readonly attribute on these files? To uncheck them you
> will need to detach the database again.
> How did you move the files?
> John|||Hi Dan
"Dan D." wrote:
> I didn't get an error. I did this twice on two different databases and had
> the same problem both times. I didn't check the readonly attribute but since
> I moved the files using drag-and-drop, I wouldn't expect the attribute to
> change.
> I had a backup of the database and I restored it and didn't have any problem.
> Thanks,
> --
> Dan D.
If you didn't get an error changing the database from readonly the file
attributes must be ok. I did find this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303056&SiteID=1 where
the service accounts permissions on the directory has an impact, so it may be
your permissions rather than the service accounts if you backup/restore works
ok.
John
John|||Hi,
I know that in SQL 2005 when attaching databases they come up in a state of
reduced functinality. This is a security measure to make sure that someone
cannot attach a database that gives them more permsissions than they might
otherwise have. Maybe some of this concept made it into SQL2000 SP4.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:5F9EE66C-31AC-4AC6-A971-7613346DBE1D@.microsoft.com...
> Using SS2000 SP4. I've done this many times before without problem so I
> don't
> know why I'm having trouble this time. I'm running out of space on a drive
> so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.|||It was the security on the folder that I was moving the data to. The user
didn't have enough permissions.
Thanks,
--
Dan D.
"John Bell" wrote:
> Hi Dan
> "Dan D." wrote:
> > I didn't get an error. I did this twice on two different databases and had
> > the same problem both times. I didn't check the readonly attribute but since
> > I moved the files using drag-and-drop, I wouldn't expect the attribute to
> > change.
> >
> > I had a backup of the database and I restored it and didn't have any problem.
> >
> > Thanks,
> > --
> > Dan D.
> If you didn't get an error changing the database from readonly the file
> attributes must be ok. I did find this
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303056&SiteID=1 where
> the service accounts permissions on the directory has an impact, so it may be
> your permissions rather than the service accounts if you backup/restore works
> ok.
> John
> John

moving a database causes it to be read-only

Using SS2000 SP4. I've done this many times before without problem so I don't
know why I'm having trouble this time. I'm running out of space on a drive so
I'm moving some databases to another drive. I've tried this with EM and QA
using this query:
EXEC sp_detach_db 'jg', 'false'
EXEC sp_attach_db @.dbname = 'jg',
@.filename1 = 'S:\SQL\Data\jg_Data.mdf',
@.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
After attaching the database, the database comes up read-only. Can someone
tell me why?
Thanks,
Dan D.
Hi Dan
"Dan D." wrote:

> Using SS2000 SP4. I've done this many times before without problem so I don't
> know why I'm having trouble this time. I'm running out of space on a drive so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.
Do you get an error when you try to make them not read-only?
Have you checked the readonly attribute on these files? To uncheck them you
will need to detach the database again.
How did you move the files?
John
|||I didn't get an error. I did this twice on two different databases and had
the same problem both times. I didn't check the readonly attribute but since
I moved the files using drag-and-drop, I wouldn't expect the attribute to
change.
I had a backup of the database and I restored it and didn't have any problem.
Thanks,
Dan D.
"John Bell" wrote:

> Hi Dan
> "Dan D." wrote:
>
> Do you get an error when you try to make them not read-only?
> Have you checked the readonly attribute on these files? To uncheck them you
> will need to detach the database again.
> How did you move the files?
> John
|||Hi Dan
"Dan D." wrote:

> I didn't get an error. I did this twice on two different databases and had
> the same problem both times. I didn't check the readonly attribute but since
> I moved the files using drag-and-drop, I wouldn't expect the attribute to
> change.
> I had a backup of the database and I restored it and didn't have any problem.
> Thanks,
> --
> Dan D.
If you didn't get an error changing the database from readonly the file
attributes must be ok. I did find this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303056&SiteID=1 where
the service accounts permissions on the directory has an impact, so it may be
your permissions rather than the service accounts if you backup/restore works
ok.
John
John
|||Hi,
I know that in SQL 2005 when attaching databases they come up in a state of
reduced functinality. This is a security measure to make sure that someone
cannot attach a database that gives them more permsissions than they might
otherwise have. Maybe some of this concept made it into SQL2000 SP4.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:5F9EE66C-31AC-4AC6-A971-7613346DBE1D@.microsoft.com...
> Using SS2000 SP4. I've done this many times before without problem so I
> don't
> know why I'm having trouble this time. I'm running out of space on a drive
> so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.
|||It was the security on the folder that I was moving the data to. The user
didn't have enough permissions.
Thanks,
Dan D.
"John Bell" wrote:

> Hi Dan
> "Dan D." wrote:
>
> If you didn't get an error changing the database from readonly the file
> attributes must be ok. I did find this
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303056&SiteID=1 where
> the service accounts permissions on the directory has an impact, so it may be
> your permissions rather than the service accounts if you backup/restore works
> ok.
> John
> John
sql

moving a database

Using SS2000 SP3. I'm trying to move a database using:
EXEC sp_detach_db 'vesta_archive', 'false'
but I get a "cannot detach the database 'vesta_archive' because it is
currently in use."
There is no one here and no dts packages running. Is there any way to tell
who might be using the database or is there maybe another reason for this
message?
Thanks,
--
Dan D.Try sp_who, and then look at column loginame, and dbname column.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.|||Dan,
When I get such a message it is often me.
Do you have Enterprise manager open to that database? Another Query
Analyzer panel that is in that database? Etc?
Russell Fields
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.|||Thanks. I found the culprit.
"Gregory A. Larsen" wrote:

> Try sp_who, and then look at column loginame, and dbname column.
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>|||Thanks. I found the person.
"Russell Fields" wrote:

> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>|||Russell, I agree. It's often the DBA. Sometimes even if you switch the
highlight to a non database object in Enterprise Manager, sp_who2 still
shows you are connected. In this case, I have to disconnect ...
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23s7UjDfhEHA.1184@.TK2MSFTNGP12.phx.gbl...
> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
tell[vbcol=seagreen]
this[vbcol=seagreen]
>|||More information needed than this.|||Arc Serve has a database containing the information of the datastore
including indexes references etc. This is needed if a restore is going t
o
be done. I would like this database that arcserve creates to be put into
an SQL database, instead of residing on my local drive.
"unc27932@.yahoo.com" wrote:

> More information needed than this.
>

moving a database

Using SS2000 SP3. I'm trying to move a database using:
EXEC sp_detach_db 'vesta_archive', 'false'
but I get a "cannot detach the database 'vesta_archive' because it is
currently in use."
There is no one here and no dts packages running. Is there any way to tell
who might be using the database or is there maybe another reason for this
message?
Thanks,
Dan D.
Try sp_who, and then look at column loginame, and dbname column.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.
|||Dan,
When I get such a message it is often me.
Do you have Enterprise manager open to that database? Another Query
Analyzer panel that is in that database? Etc?
Russell Fields
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.
|||Thanks. I found the culprit.
"Gregory A. Larsen" wrote:

> Try sp_who, and then look at column loginame, and dbname column.
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>
|||Thanks. I found the person.
"Russell Fields" wrote:

> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>
|||Russell, I agree. It's often the DBA. Sometimes even if you switch the
highlight to a non database object in Enterprise Manager, sp_who2 still
shows you are connected. In this case, I have to disconnect ...
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23s7UjDfhEHA.1184@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
tell[vbcol=seagreen]
this
>
|||More information needed than this.
|||Arc Serve has a database containing the information of the datastore
including indexes references etc. This is needed if a restore is going to
be done. I would like this database that arcserve creates to be put into
an SQL database, instead of residing on my local drive.
"unc27932@.yahoo.com" wrote:

> More information needed than this.
>