January 14, 2009 at 11:37 am
hi,
we need to add some startup parameters to analyze dump files as MS suggested.
Registry startup parameters:
-l D:\Microsoft SQL Server\MSSQL.5\MSSQL\DATA\mastlog.ldf
-e D:\Microsoft SQL Server\MSSQL.5\MSSQL\LOG\ERRORLOG
-d D:\Microsoft SQL Server\MSSQL.5\MSSQL\DATA\master.mdf
T815
T818,T2551
We like the above in sql server configuration manager.Here my question is do We need to add (-) before the trace flags or not?
-T815
-T818,-T2551 or
T815
T818,T2551
Thanks
January 14, 2009 at 11:44 am
You will need to add the "-", an example is:
-T3226;-lE:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-eE:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-dE:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
January 14, 2009 at 12:01 pm
but without - before the trace file also working and from the error log I got the below message
-l D:\Microsoft SQL Server\MSSQL.5\MSSQL\DATA\mastlog.ldf
2009-01-14 10:56:49.42 Server -e D:\Microsoft SQL Server\MSSQL.5\MSSQL\LOG\ERRORLOG
2009-01-14 10:56:49.42 Server -d D:\Microsoft SQL Server\MSSQL.5\MSSQL\DATA\master.mdf
2009-01-14 10:56:49.42 Server T815
2009-01-14 10:56:49.42 Server T818,T2551
is that fine or do we need to - compulsary?
January 14, 2009 at 12:11 pm
With flag 3226, I can verify that without the "-", the error log shows that the flag is present in the config, but the desired result (no successful backup message in errorlog) is not present.
I've never used those specific flags, but I will presume the same is true.
Kyle
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply