Post reply

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

  • 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

  • February 4, 2010 at 12:26 am

    #1113506

    Hi;

    Is no one to solve this thread.

    Ram
    MSSQL DBA

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply