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

Move from active/passive cluster to active/active

Hi,
sorry for my lack of knowledge on this issue..
I've installed a Windows 2003 Cluster with SQL 2005. Works like a charm
when i do a failover.
Now i want to make this cluster active/active (multi instance) so no
connection is lost when a node goes down, but can't find any info on
how this need to be done. Can anyone help me out here..?!
Thanx in advance!
Hiddo,
"to make this cluster active/active (multi instance) so no connection is
lost when a node goes down"
When a cluster-group, or instance, moves from one node to another you do
loose your connection, as it offlines the group completely when moving.
Having a multi-instance, doesn't help, multi-instance is just another word
for having multiple virtual servers, they are still seperate in regards to
databases and connections. (e.g. if you have 2 instances, you can consider
them as being 2 different servers)
I do not think that your problem can be solved by server clustering.
HTH,
_Edwin.
<hiddo.vanloon@.gmail.com> wrote in message
news:1166449613.633338.27770@.t46g2000cwa.googlegro ups.com...
> Hi,
> sorry for my lack of knowledge on this issue..
> I've installed a Windows 2003 Cluster with SQL 2005. Works like a charm
> when i do a failover.
> Now i want to make this cluster active/active (multi instance) so no
> connection is lost when a node goes down, but can't find any info on
> how this need to be done. Can anyone help me out here..?!
> Thanx in advance!
>
|||a Network Load balanced cluster is something then a multi instance
cluster right?!
hiddo.vanloon@.gmail.com schreef:

> Hi,
> sorry for my lack of knowledge on this issue..
> I've installed a Windows 2003 Cluster with SQL 2005. Works like a charm
> when i do a failover.
> Now i want to make this cluster active/active (multi instance) so no
> connection is lost when a node goes down, but can't find any info on
> how this need to be done. Can anyone help me out here..?!
> Thanx in advance!
|||NLB is indeed different then failover clustering, however not really usable
with databases such as SQL.
You need to think of your requirements, and then match it to the right
technology option for SQL
Here are some links for reference:
(some are SQL2000, but still applicable for most part)
Failover Clustering
http://msdn2.microsoft.com/en-gb/library/ms189134.aspx
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
Scaling Out SQL Server with Data Dependent Routing
http://www.microsoft.com/technet/prodtechnol/sql/2005/scddrtng.mspx
Federated SQL Server 2000 Servers
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_4fw3.asp
Federated Database Servers
http://msdn2.microsoft.com/en-us/library/ms190381.aspx
Scaling out SQL 2005
http://msdn2.microsoft.com/en-us/library/aa479364.aspx
HTH,
Rgds,
Edwin.
<hiddo.vanloon@.gmail.com> wrote in message
news:1166450266.512747.218020@.l12g2000cwl.googlegr oups.com...
> a Network Load balanced cluster is something then a multi instance
> cluster right?!
> hiddo.vanloon@.gmail.com schreef:
>
|||Edwin,
Thanx for your support! It's become more clear to me now...
Nog 1 vraag ... : )
Hoe verwijder ik een Windows 2003 cluster in z'n geheel. Ik draai (voor
test) een 2-node W2k3/SQL2k5 cluster en deze wil ik dus in z'n geheel
verwijderen.
Wanneer ik op de eerst node 'take offline' kies en vervolgens Evict
Node gaat dit goed, alleen bij de 2de node krijg ik RPC errors
(waarschijnlijk omdat hierop het virtuele cluster ip nog draait..)
Gr,
Hiddo
Edwin vMierlo schreef:
[vbcol=seagreen]
> NLB is indeed different then failover clustering, however not really usable
> with databases such as SQL.
> You need to think of your requirements, and then match it to the right
> technology option for SQL
> Here are some links for reference:
> (some are SQL2000, but still applicable for most part)
> Failover Clustering
> http://msdn2.microsoft.com/en-gb/library/ms189134.aspx
> SQL Server 2000 Failover Clustering
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> Scaling Out SQL Server with Data Dependent Routing
> http://www.microsoft.com/technet/prodtechnol/sql/2005/scddrtng.mspx
> Federated SQL Server 2000 Servers
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_4fw3.asp
> Federated Database Servers
> http://msdn2.microsoft.com/en-us/library/ms190381.aspx
> Scaling out SQL 2005
> http://msdn2.microsoft.com/en-us/library/aa479364.aspx
>
> HTH,
> Rgds,
> Edwin.
>
> <hiddo.vanloon@.gmail.com> wrote in message
> news:1166450266.512747.218020@.l12g2000cwl.googlegr oups.com...
|||Hiddo,
Good practice is to keep posts in these newsgroups in english. This so
others can read the posts and possibly help themselves solving problems.
There are however some newsgroups for some topics in your native language,
they have the microsoft.public.nl.... prefix.
In regards to your question of fully removing a W2K3/SQL2K5 cluster,
first, remove SQL instances:
http://msdn2.microsoft.com/en-us/library/ms190438.aspx
then, remove the cluster:
http://support.microsoft.com/kb/282227
Good Luck !
Rgds,
Edwin.
<hiddo.vanloon@.gmail.com> wrote in message
news:1166452564.987411.275060@.n67g2000cwd.googlegr oups.com...[vbcol=seagreen]
> Edwin,
> Thanx for your support! It's become more clear to me now...
> Nog 1 vraag ... : )
> Hoe verwijder ik een Windows 2003 cluster in z'n geheel. Ik draai (voor
> test) een 2-node W2k3/SQL2k5 cluster en deze wil ik dus in z'n geheel
> verwijderen.
> Wanneer ik op de eerst node 'take offline' kies en vervolgens Evict
> Node gaat dit goed, alleen bij de 2de node krijg ik RPC errors
> (waarschijnlijk omdat hierop het virtuele cluster ip nog draait..)
> Gr,
> Hiddo
>
> Edwin vMierlo schreef:
usable[vbcol=seagreen]
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx[vbcol=seagreen]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_4fw3.asp[vbcol=seagreen]
charm
>

move distribution database to other storage

I've got a couple of replicated databases and I've found myself in the
position of wanting to move my distribution database to a different storage
volume. Enterprise manager considers it replicated, so I can't just detach
it, copy and reattach. Anyone know of a good way to do this?
Thanks!
Patrick Peters
patrick.peters at orametrix dot com (fix the reply address for this message
if you're sending email to me)
Hi,
I think you need to completely remove replication and then start over from
start.
Thanks
Hari
SQL Server MVP
"Patrick Peters" <patrick.peters at orametrix dot com> wrote in message
news:uLz0vzFnFHA.1968@.TK2MSFTNGP14.phx.gbl...
> I've got a couple of replicated databases and I've found myself in the
> position of wanting to move my distribution database to a different
> storage volume. Enterprise manager considers it replicated, so I can't
> just detach it, copy and reattach. Anyone know of a good way to do this?
> Thanks!
> Patrick Peters
> patrick.peters at orametrix dot com (fix the reply address for this
> message if you're sending email to me)
>
|||I was hoping for something less painfull than that. This is, however, what
we ended up doing. Luckily the amount of data involved is small right now.
In a couple of months, this solution would have been unacceptable.
Pat
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OQ4ehNGnFHA.3448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I think you need to completely remove replication and then start over from
> start.
> Thanks
> Hari
> SQL Server MVP
> "Patrick Peters" <patrick.peters at orametrix dot com> wrote in message
> news:uLz0vzFnFHA.1968@.TK2MSFTNGP14.phx.gbl...
>