how to remove trace flag in startup option

Hi,
I am having a problem and please help. I tried to add a trace flag -g512 to
our sql 2005 sp2 clustered instance. I added to the startup parameters line
of the SQL configuration manager, something like this:
-dT:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\master.mdf;-eT:\Microsoft
SQL Server\msql\MSSQL.1\MSSQL\LOG\ERRORLOG;-lT:\Microsoft SQL
Server\msql\MSSQL.1\MSSQL\DATA\mastlog.ldf -g512
after this I cannot get SQL started up. And I tried to manually remove this
flag from registry and sql does not start. When I looked at the registry, it
is back again. Please help.
Thanks very much.
--
BrianThe options need to be separated by semi-colon. Look at that last option. SQL Server will try to use
for the master database log file a file named: "mastlog.ldf -g512". Set a semi-colon after the file
name.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
news:B5B10076-C531-43FC-A627-1355455320F2@.microsoft.com...
> Hi,
> I am having a problem and please help. I tried to add a trace flag -g512 to
> our sql 2005 sp2 clustered instance. I added to the startup parameters line
> of the SQL configuration manager, something like this:
> -dT:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\master.mdf;-eT:\Microsoft
> SQL Server\msql\MSSQL.1\MSSQL\LOG\ERRORLOG;-lT:\Microsoft SQL
> Server\msql\MSSQL.1\MSSQL\DATA\mastlog.ldf -g512
> after this I cannot get SQL started up. And I tried to manually remove this
> flag from registry and sql does not start. When I looked at the registry, it
> is back again. Please help.
> Thanks very much.
> --
> Brian|||Thanks Tibor,
I added a semi colon, and saved OK. when I tried to bring SQL online, it
failed. And I checked again in configuration manager, it is back to where it
was (without semi colon). Can you please help again? Maybe help me to get
this flag removed first?
Thanks.
Brian
--
Brian
"Tibor Karaszi" wrote:
> The options need to be separated by semi-colon. Look at that last option. SQL Server will try to use
> for the master database log file a file named: "mastlog.ldf -g512". Set a semi-colon after the file
> name.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
> news:B5B10076-C531-43FC-A627-1355455320F2@.microsoft.com...
> > Hi,
> >
> > I am having a problem and please help. I tried to add a trace flag -g512 to
> > our sql 2005 sp2 clustered instance. I added to the startup parameters line
> > of the SQL configuration manager, something like this:
> >
> > -dT:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\master.mdf;-eT:\Microsoft
> > SQL Server\msql\MSSQL.1\MSSQL\LOG\ERRORLOG;-lT:\Microsoft SQL
> > Server\msql\MSSQL.1\MSSQL\DATA\mastlog.ldf -g512
> >
> > after this I cannot get SQL started up. And I tried to manually remove this
> > flag from registry and sql does not start. When I looked at the registry, it
> > is back again. Please help.
> >
> > Thanks very much.
> >
> > --
> > Brian
>
>|||Here is the error:
2007-11-30 09:54:43.45 spid5s Unable to open the physical file
"T:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\mastlog.ldf -g512".
Operating system error 2: "2(The system cannot find the file specified.)".
Thanks very much.
--
Brian
"Tibor Karaszi" wrote:
> The options need to be separated by semi-colon. Look at that last option. SQL Server will try to use
> for the master database log file a file named: "mastlog.ldf -g512". Set a semi-colon after the file
> name.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
> news:B5B10076-C531-43FC-A627-1355455320F2@.microsoft.com...
> > Hi,
> >
> > I am having a problem and please help. I tried to add a trace flag -g512 to
> > our sql 2005 sp2 clustered instance. I added to the startup parameters line
> > of the SQL configuration manager, something like this:
> >
> > -dT:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\master.mdf;-eT:\Microsoft
> > SQL Server\msql\MSSQL.1\MSSQL\LOG\ERRORLOG;-lT:\Microsoft SQL
> > Server\msql\MSSQL.1\MSSQL\DATA\mastlog.ldf -g512
> >
> > after this I cannot get SQL started up. And I tried to manually remove this
> > flag from registry and sql does not start. When I looked at the registry, it
> > is back again. Please help.
> >
> > Thanks very much.
> >
> > --
> > Brian
>
>|||The semi-colon is probably removed by the cluster handling. Does it work if you use the SQL Server
Configuration Manager application (which I assume is cluster-aware)?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
news:4167E684-0A13-4358-BAE1-58B30E6288AD@.microsoft.com...
> Thanks Tibor,
> I added a semi colon, and saved OK. when I tried to bring SQL online, it
> failed. And I checked again in configuration manager, it is back to where it
> was (without semi colon). Can you please help again? Maybe help me to get
> this flag removed first?
> Thanks.
> Brian
> --
> Brian
>
> "Tibor Karaszi" wrote:
>> The options need to be separated by semi-colon. Look at that last option. SQL Server will try to
>> use
>> for the master database log file a file named: "mastlog.ldf -g512". Set a semi-colon after the
>> file
>> name.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
>> news:B5B10076-C531-43FC-A627-1355455320F2@.microsoft.com...
>> > Hi,
>> >
>> > I am having a problem and please help. I tried to add a trace flag -g512 to
>> > our sql 2005 sp2 clustered instance. I added to the startup parameters line
>> > of the SQL configuration manager, something like this:
>> >
>> > -dT:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\master.mdf;-eT:\Microsoft
>> > SQL Server\msql\MSSQL.1\MSSQL\LOG\ERRORLOG;-lT:\Microsoft SQL
>> > Server\msql\MSSQL.1\MSSQL\DATA\mastlog.ldf -g512
>> >
>> > after this I cannot get SQL started up. And I tried to manually remove this
>> > flag from registry and sql does not start. When I looked at the registry, it
>> > is back again. Please help.
>> >
>> > Thanks very much.
>> >
>> > --
>> > Brian
>>