How to change stopped SQL Server 2000 startup parameters by using SQL Server 2008 Configuration manager!

• Reo

  Hall of Fame

  Points: 3774

  More actions

  February 2, 2010 at 8:26 am

  #216236

  Hi all;

  I have a SQL Server 2000 Cluster and another SQL Server 2008 Instance is running on passive node of the cluster (as a stand by Instance). Now I have changed startup parameter on SQL 2000 and restart SQL 2000 but unfortunately the SQL 2000 service not starting due to wrong startup parameter. I know that my SQL Server 2000 Cluster service not starting due to wrong parameter setting.

  My startup parameters are: -T3226, -T1204, -T3605

  My questions are:

  1.How I can change startup parameters on stopped SQL Server 2000

  2.Is there any possibility to change SQL Server 2000 startup parameters by using SQL Server 2008 configuration manager?

  Yes! I have studied the Microsoft Article http://support.microsoft.com/kb/912397/

  But is there any other way!

  Thanks in Advance for all experienced DBAs

  Ram
  MSSQL DBA

• Reo

  Hall of Fame

  Points: 3774

  More actions

  February 4, 2010 at 12:26 am

  #1113506

  Hi;

  Is no one to solve this thread.

  Ram
  MSSQL DBA

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  February 4, 2010 at 3:02 pm

  #1114038

  See if this link helps (thanks Google)

  http://www.mssqltips.com/tip.asp?tip=960

  I have done it in 2005 but not for 2000

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005