all groups > sql server clustering > january 2006 > threads for january 15 - 21, 2006
Filter by week: 1 2 3 4 5
Moving SQL 2005 DB's
Posted by Kevin Antel at 1/19/2006 2:28:31 PM
2 Questions Actually!
1. I know how to move all the system DB's in 2000, but I am a bit confused
as to how to accomplish this in 2005.
I need to move:
Master
Model
MSDB
I've already moved Temp.
2. Now, there is this other DB, called the resource DB, which they tell you
not to re... more >>
Clustered SQL 2005 Standard
Posted by Kevin Antel at 1/19/2006 1:02:53 PM
I just completed an install of SQL 2005 Standard into a newly formed
cluster. I basically installed every option for SQL 2005 Server, however,
the only resources added to the cluster group were SQL Server, SQL Agent and
SQL Server Fulltext.
I would have thought reporting services would hav... more >>
Reboot SAN of SQL Cluster
Posted by RobinMC at 1/19/2006 10:09:03 AM
We are planning a recycle of our SAN to which our active/passive 2-node SQL
cluster is attached. Is there anything special to be aware of?
We will do the following steps:
Pause the passive node
using Cluster Admin, stop SQL service
Power down active node server
power down passive node serv... more >>
Cluster DR
Posted by John Smith at 1/17/2006 4:53:49 PM
My production cluster disks are corruptd - i would like to find out how to
restore from backups
I have all system backups and mdf and ldf files of the databases - I would
like to keep the logins, jobs etc
Thanks
... more >>
Cluster Upgrade
Posted by Seme Rollansa at 1/17/2006 4:50:07 PM
Hi,
We have a cluster (2node, 8Way, 8GB) running windows 2000 Advanced. We would
like to upgrade to windows 2003 Enterprise Edition
Whats the easiest way to accmplish this ? what are the options ? are there
any links ?
... more >>
Reboot? How often?
Posted by rk rider at 1/17/2006 10:10:03 AM
We currently have SQL server EE running on Windows Server 2003 EE in a 2 node
active/passive cluster. We want to restart periodically but not too often.
What is the best way to do this? What I've been doing is move the resources
to the inactive side of the cluster then rebooting the passive no... more >>
Newb question regarding cluster load balancing
Posted by Michael Weyant at 1/16/2006 10:45:38 AM
Hello to all,
I am currently working on creating a Windows 2003 server cluster (3 nodes)
with the intent that it serve our web app which requires multiple SQL
databases. The question I have is this: How can I configure load balancing
for this? It seems that clustering services only allows 1... more >>
SQL Hotfixes - Adding New Node to Cluster
Posted by Norb at 1/16/2006 6:37:02 AM
I have a 4 node Windows 2003/SQL 2000 cluster that started out as a three
node cluster. I just added another node and new instance. Everything went
great on the Windows/cluster side, everything fine on the SQL side for that
instance.
When I went to add the new node to the other two inst... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Timeout
Posted by naruphon at 1/15/2006 1:35:00 AM
My application record the SQL Timeout in the log file. The application
server calls SQL on cluster via ADO. The error is always when the batch
processing is running. Can anyone here advise me on how do I expand the
time-out on SQL cluster? I am using SQL 2000 SP3
Best Regards,
Naruphon
... more >>
|