dbTalk Databases Forums  

URGENT ISSUE: Startup Parameter - Flag T1118

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss URGENT ISSUE: Startup Parameter - Flag T1118 in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
salsafreak
 
Posts: n/a

Default URGENT ISSUE: Startup Parameter - Flag T1118 - 11-16-2007 , 05:42 PM






Our env: SQL Server 2005 Ent SP2 64-bit, two-node single-instance failover
cluster, Win2003 Ent SP1, 16GB

Here's our problem: The startup parameters were modified using SQL Cong Mgr
by adding a -T1118 at end (recommended when doing tempdb striping). We keep
getting error on SQL service startup (after failing over) that it thinks the
flag is part of the master database file name and it fails!!

Any help will be appreciated.
Thanks

Reply With Quote
  #2  
Old   
salsafreak
 
Posts: n/a

Default RE: URGENT ISSUE: Startup Parameter - Flag T1118 - 11-16-2007 , 05:45 PM






Exact message is:
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file
'D:\MSSQL05\DATA\MSSQL.1\MSSQL\DATA\mastlog.ldf -T1118'. Diagnose and correct
the operating system error, and retry the operation.

"salsafreak" wrote:

Quote:
Our env: SQL Server 2005 Ent SP2 64-bit, two-node single-instance failover
cluster, Win2003 Ent SP1, 16GB

Here's our problem: The startup parameters were modified using SQL Cong Mgr
by adding a -T1118 at end (recommended when doing tempdb striping). We keep
getting error on SQL service startup (after failing over) that it thinks the
flag is part of the master database file name and it fails!!

Any help will be appreciated.
Thanks

Reply With Quote
  #3  
Old   
salsafreak
 
Posts: n/a

Default RE: URGENT ISSUE: Startup Parameter - Flag T1118 - 11-16-2007 , 06:20 PM



Fix was found in an obscure kb article (protocol parameter? we were looking
for startup parameter!!)
http://support.microsoft.com/kb/912397


"salsafreak" wrote:

Quote:
Exact message is:
FCB::Open: Operating system error 2(The system cannot find the file
specified.) occurred while creating or opening file
'D:\MSSQL05\DATA\MSSQL.1\MSSQL\DATA\mastlog.ldf -T1118'. Diagnose and correct
the operating system error, and retry the operation.

"salsafreak" wrote:

Our env: SQL Server 2005 Ent SP2 64-bit, two-node single-instance failover
cluster, Win2003 Ent SP1, 16GB

Here's our problem: The startup parameters were modified using SQL Cong Mgr
by adding a -T1118 at end (recommended when doing tempdb striping). We keep
getting error on SQL service startup (after failing over) that it thinks the
flag is part of the master database file name and it fails!!

Any help will be appreciated.
Thanks

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.