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
>>

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. SQ
L Server will try to use
for the master database log file a file named: "mastlog.ldf -g512". Set a se
mi-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 t
o
> our sql 2005 sp2 clustered instance. I added to the startup parameters lin
e
> of the SQL configuration manager, something like this:
> -dT:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\master.mdf;-eT:\Microsof
t
> 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 thi
s
> 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...
>
>|||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...
>
>|||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...[vbcol=seagreen]
> 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:
>

How to remove (uninstall ) cluster sql server manually?

Hi All,
Environment:windows2003 sp1
SQl server 2000, sp2, and It is clustered(2 nodes)
I need to uninstall SQL server2000 . When i tried to uninstall from setup,
i have got error and so i have deleted manually so sql binaries and registry
key(services\mssqlserver and sqlagent).
Now i am not able to uninstall completely..
Can anyone help me what are the registry keys, files etc need to be deleted
for this unstallation to complete?How to clean it properly?
Thanks in adavnce
Suchi
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:CC2377D2-7128-4C59-AF25-29136F9AB016@.microsoft.com...
> Hi All,
> Environment:windows2003 sp1
> SQl server 2000, sp2, and It is clustered(2 nodes)
> I need to uninstall SQL server2000 . When i tried to uninstall from
> setup,
> i have got error and so i have deleted manually so sql binaries and
> registry
> key(services\mssqlserver and sqlagent).
> Now i am not able to uninstall completely..
> Can anyone help me what are the registry keys, files etc need to be
> deleted
> for this unstallation to complete?How to clean it properly?
> Thanks in adavnce
> Suchi
|||Thanks Hiten for the quick reponse.
I have gone through the below Link before uninstalling .
As i was getting error while uninstalling from setup(method 2),I removed the
data and some of binaries . I cloud not delete the reg key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer.
Getting "Cannot delet MSsqlserver: Error while deleting key" error.
SQL server is clustered.Even i could not delet some binaries. Getting access
denied error. I am using admin account with full permissions..
Thanks..
Suchi
"Geoff N. Hiten" wrote:

> How to manually remove SQL Server 2000 default, named, or virtual instance
> http://support.microsoft.com/kb/290991/en-us
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:CC2377D2-7128-4C59-AF25-29136F9AB016@.microsoft.com...
>
|||You may have to reboot nodes to clear some leftover file locks.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:2CBE9799-2529-40D0-B4F3-621629258E63@.microsoft.com...[vbcol=seagreen]
> Thanks Hiten for the quick reponse.
> I have gone through the below Link before uninstalling .
> As i was getting error while uninstalling from setup(method 2),I removed
> the
> data and some of binaries . I cloud not delete the reg key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer.
> Getting "Cannot delet MSsqlserver: Error while deleting key" error.
> SQL server is clustered.Even i could not delet some binaries. Getting
> access
> denied error. I am using admin account with full permissions..
> Thanks..
> Suchi
> "Geoff N. Hiten" wrote:
|||Hiten,
can you please let me know any reg keys need to be deleted before rebooting?
"Geoff N. Hiten" wrote:

> You may have to reboot nodes to clear some leftover file locks.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:2CBE9799-2529-40D0-B4F3-621629258E63@.microsoft.com...
>
|||It sounds like you may have some SQL services still running. That will lock
down certain file folders and possibly registry keys. Stop all the SQL
services and follow the instructions that match your setup (named or default
instance) exactly on all nodes. If something prevents a folder or reg key
deletion, then it is time to reboot, verify the services are not running,
and try again.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:07AC7A23-0505-473D-BC3D-FFB13321AC07@.microsoft.com...[vbcol=seagreen]
> Hiten,
> can you please let me know any reg keys need to be deleted before
> rebooting?
> "Geoff N. Hiten" wrote:
|||You my need to remove some virtual resources if the processes outlined in
the KB article do not clear them out. Basically, try and get the cluster
back to where it was before the blown SQL install.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:CEF3C105-C5F4-4B53-926A-B4D90C8CD53F@.microsoft.com...[vbcol=seagreen]
> Thanks much..
> Do i need to delete resources from cluster admin?
> If yes, is it from resorces or from groups?
>
> "Geoff N. Hiten" wrote: