View Complete Post
I have SQL Server 2005 std edition installed on a windows 2003 clustered server. As integration services does not support i was asked to install it as a standalone on both nodes. When I had started the setup it showing on both the nodes. How do i
install it only one node at a time and not on the cluster. Do i need to have separate instance of sql server too.
Storage engineers are planning to Upgrade storage Drive and that storage using for SQL Server 2005 Active /Passive cluster.
as DBA what action I have to take.
I am planning
1.Backup all Databases.(Inluding system)
2.Takning all Databases OFFLINE(make sure no body using Databases)
3.Stopping Instance and Agent .
which is the best way.
any advise is helpful for me.
We have a 2 node SQL Failover Cluster (2008).
We wish to replace these 2 Servers (Virtual Machines) with 2 new ones. I was hoping I could 'cheat' and instead of powering off both current Virtual Machines and then having to do the SQL install from scratch on the 2 new Servers. I could do the following
A: Add the 2 new Virtual Machines as additional Failover Clusters into the current SQL Environment (so we now have a 4 node SQL Cluster)
B: Power off the 2 OLD Virtual Machines (so the 2 new Virtual Machines make up the new Cluster)
Would this work or would it be looking for certain files, etc that were installed on the Primary Node?
I have a 2 Node SQL Cluster. Node A is the Primary Box where SQL was first installed and Node B is the Secondary Box where I added it to the Failover Cluster.
I now wish to replace Node A with a new Server (reason being, we have had issues with this and wish to rebuild it from scratch). My question is...
If I move the SQL Resources onto Node B, can I then rebuild Node A Server and then add it as 'failover cluster node'? Or will this not work as it will already detect that Node A was part of this Cluster before? And during the initial install did Node
A install files that are required for Node B to work?
Is it required now to upgrade to SharePoint 2010 Foundation etc. first before using Office 2010 with SharePoint??
Or can Office 2010 work in even a limited manner with WSS 3.0??
Thank you, Tom
Please some body help me to find Hot fixes for Windows 2003 SP2 to install SQL Server 2008 R2 In Cluster environment.
Thanks in Advance
I have just installed MOSS 2007 on a machine with 64-bit Win 2K3. It installs fine but after installation navigating to the Central Administration site yields a "Service Unavailable" message.
I tried searching for reasons for this, but the event viewer has no significant logs, and the relevant services (World Wide Wed Publishing Service, Windows SharePoint Services Administration, and Windows SharePoint Services Timer are all started.
I had previously installed and run MOSS 2007 successfully on this machine, but had to uninstall and reinstall for an unconnected reason. After reinstalling, I am now getting the "Service Unavailable" error.
Can someone give me an idea what to look into to debug this issue? Thanks in advance.
Hi Microsoft support,
I would like to report a problem when installing SQL 2005 “SP3 SQLServer2005SP3-KB955706-x86-ENU.exe” onto a W2003 SP2 MS cluster sharing disks on a EVA SAN. Please see attached log file for the patching process.
The patching fail with the following depending on database instance :
“10/31/2010 14:34:17.488 MSP Error: 29512 SQL Server Setup was unable add user ETMC\PACS_Service to local group ETMC\PACS_Core_Users.
10/31/2010 14:34:36.253 MSP returned 1603: A fatal error occurred during installation.”
Description of patching process:
Patching has been tried with two supported methods. Executed from the active node where the patching on the passive node is done automatically by the patching program itself sending the software over to passive node. And by pausing the passive node only
installing on the active node where no attempt is done to install on the passive node but should be then done by moving over database package to passive node (to become active) and do the same from there pausing the previous active node). It was discovered
that on node A: the drive: becomes full in the middle of th
Does anyone have any clue that why RDP just suddenly stopped working after installing Moss 2007?
I have installed MOSS 2007 sp2 and would like to know when we install the SP2 will it make any changes to standard layouts folder (changes in any files).
I have two servers with SQL 2005 running as separate instances. I now want to install a cluster over the two boxes with SQL Server 2008R2 while keeping the 2005 instances running for a while. The databases will then be migrated over from the 2005 instances
to the cluster for testing. After a test period, the 2005 instances will have a final migration and be decommissioned.
So for server001, server002 and SQL Cluster name SQLCLU001, I should be able to reference them all on the network individually after installation and the individual instances will continue to run on the local disk until decommissioned IIRC.
From what i've done before, I think this should be fine and shouldn't throw any issues but I wanted to check that there weren't any obvious blockers to this. Licenses are all ok, servers are fast enough to cope with the new configuration. It's just the process
I wanted to check out as i've not done an upgrade in quite this way before