July 3, 2007 at 11:42 pm
Has anyone rebuilt system databases for a SQL2005 clustered instance?
I have followed the code from "To rebuild system databases for a clustered." section at http://msdn2.microsoft.com/en-us/library/ms144259.aspx, and keep getting message saying to add more parameters. When finally \90\Setup Bootstrap\LOG\Summary.txt says "Setup succeeded with the installation", the system databases are not actually rebuilt and the log files under \Setup Bootstrap\LOG\Files have a lot of errors and exceptions.
What are all the parameters needed for rebuilding sys databases on a cluster? Is there anything should be aware of?
July 4, 2007 at 12:36 am
I hope the link that you are using is for installing sql server in clustered environment. When you have to rebuild the sql serve you will have to start the setup from the command line using rebuild=1 switch so that yuor server gets rebuilt.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 4, 2007 at 5:35 am
Thank you for your reply. I need to rebuild system databases, not the entire sql server.
July 4, 2007 at 7:03 am
Rebuilding master is like rebuilding the SQL Server. Once you rebuild master database you will lose all information like the user database, logins, etc. So before you rebuild the system database you need to take backup of all those and script the logins, jobs, etc and the rebuild the master database by calling the setup from the command prompt with a additional switch rebuild=1
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 4, 2007 at 7:06 am
You can use the below links for your reference.
http://msdn2.microsoft.com/en-us/library/ms143269.aspx
msdn2.microsoft.com/en-us/library/ms190190.aspx
geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 4, 2007 at 7:19 am
Thank you Sugesh for your suggestion.
rebuild = 1 or rebuiddatabase = 1?
I have rebuilt system databases on a stand alone SQL server using rebuilddatabase = 1 and restored recent sys DB backups. It worked fine.
Why on cluster instance it does not work? or have to rebuild SQL server again? I am thinking the downtime.
July 4, 2007 at 7:36 am
Vivien,
This link given below will be the best use for you.
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 4, 2007 at 7:43 am
Hi Sugesh, Thank you for dedicated help. Actually, I followed this link to rebuild sys DBs for both cluster and stand alone servers.
The section I followed for cluster is "To rebuild system databases for a clustered instance of SQL Server 2005 from the command prompt" section.
July 4, 2007 at 7:59 am
Yes you have followed th right section in that link that how you need to rebuild the clustered instances. If you are not opting for any major changes then you can copy paste the command and run in your server and do only the changes what it requires.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 4, 2007 at 9:26 am
Yes, I added the parameter whenever it required, "Group", then "addnode", even INSTALLSQLDATADIR = "S:\" which data should go.
The summary.txt says "Setup succeeded with the installation". But in the files\setup_*_core.log for both node2, I have this error:
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 0
Aborting queue processing as nested installer has completed
Message pump returning: 0
I want to know whether anyone has similar problem or succeed when rebuild system DBs for a cluster.
July 9, 2007 at 5:54 am
Vivien
Have you fixed this problem. If so let mw know how.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 9, 2007 at 7:17 pm
Not yet. Still looking for the resolution.
July 18, 2007 at 4:38 am
I have the same problem with a cluster. I also done a correct rebuild on a nonclustered sql2k5.
What platform is you running?
I got this one I trye with on HP BL460c with w2k3 enterprise edition x64 and sql2k5 standard edition x64. Both OS and SQL has SP2.
I got another cluster running on HP RX4640 with w2k3 enterprise edition i64 and sql2k5 enterprise edition i64. Both OS and SQL has SP2. On this one I can't try this.
I haven't tryed rebuilding sql2k5 cluster on x86.
If you got any solution, please post it.
/Peter
July 18, 2007 at 9:39 am
My platform is IBM XSERIES_3550 Windows 2003 EE SP1 then SP2 applied with SQL 2005 (3054) X86.
I have contacted MS White Paper Feedback. They did not give out helpful info. I was told to post on more forums/user groups or contact MS support directly.
I hope MS could investigate and give a clear answer. The output for executing the command does not make sense comparing with the instruction from the write paper.
For sure I will share here if I have any further info.
April 2, 2008 at 7:44 pm
I submitted a feedback to SQL Connect regarding this issue. If you like to add any comments or additional information, please go to this link. https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=336047
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply