June 17, 2011 at 3:54 am
Hi there,
I'm usign SQL Server 2008 R2 on a Win2k8 R2 Cluster.
For Single Instance I'm using this parameters:
http://technet.microsoft.com/en-us/library/ms179254(SQL.100).aspx
How is it for clusterd Instances, are there any special parameters?
Thanks for reply
Sam
June 17, 2011 at 8:06 am
It's probably less of a pain to uninstall and reinstall SQL Server, but if you want to do it this way it should work fine, just make sure you put the SQL resource offline (has to be done when you rebuild any system db).
Once its done, move the instance to another node to make sure everything is still running as expected.
June 17, 2011 at 8:17 am
I used this syntax
Setup.exe /q /ACTION=rebuilddatabase VS= [RESSOURCE]
/INSTANCENAME=[INSTANCE]
/SQLSYSADMINACCOUNTS="[ACCOUNT]"
/SAPWD="[PASSWORD]" /SQLCOLLATION=[COLATION]
IT seams everything is ok.
better then reinstall 4 Instances on 4 Nodes 🙂
Thanks anyway for your reply
cheers Sam
July 15, 2011 at 3:32 pm
Here is the script I use but did not work in clustered WINDOWS 2008R2 and SQL 2008R2 ENT 64bit, 2 nodes. I might have wrong VS name, if yes, what is the command to find correct VS name? No need SAPWD in Windows Authentication mode.
Please help.
setup.exe
/q
/ACTION=REBUILDDATABASE VS=SQL SERVER
/INSTANCENAME=ABCD123
/SQLSYSADMINACCOUNTS="DOAMIN/XYZ"
/SQLCOLLATION=SQL_Latin1_General_CP850_CI_AI
Thank you in advance.
July 15, 2011 at 3:33 pm
Here is the script I use but did not work in clustered WINDOWS 2008R2 and SQL 2008R2 ENT 64bit, 2 nodes. I might have wrong VS name, if yes, what is the command to find correct VS name? No need SAPWD in Windows Authentication mode.
Please help.
setup.exe
/q
/ACTION=REBUILDDATABASE VS=SQL SERVER
/INSTANCENAME=ABCD123
/SQLSYSADMINACCOUNTS="DOAMIN\XYZ"
/SQLCOLLATION=SQL_Latin1_General_CP850_CI_AI
Thank you in advance.
July 17, 2011 at 4:41 am
either go into Failover Cluster manager open the group and get the resource parameter from there or from a command prompt use
cluster group "groupname" /prop
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply