Posted by Erland Sommarskog on 12/03/07 23:04

Mike (huttm@yahoo.co.uk) writes:
> We are running SQL with trace flag T3608 as recommended by MS in order
> to move the msdb and model log files. That was tricky enough - SQL2005
> seems to be much pickier than 2000 when applying options:

You bet! Or more precisely, the GUI for applying startup options is
really poor.

> 2007-12-03 10:37:25.78 Server -d D:\MSSQL\DATA\master.mdf
> 2007-12-03 10:37:25.78 Server -e D:\MSSQL\LOG\ERRORLOG
> 2007-12-03 10:37:25.78 Server -l C:\MSSQL\LOGS\mastlog.ldf
> 2007-12-03 10:37:25.78 Server -m -c -T3608

This means that you did not do it right. The string you should add to
the exsting parameters are:

;-m;-c;-T3608

And when you have it right, the errorlog should read:

2007-12-04 00:04:36.03 Server -d D:\MSSQL\DATA\master.mdf
2007-12-04 00:04:36.05 Server -e D:\MSSQL\LOG\ERRORLOG
2007-12-04 00:04:36.05 Server -l CC:\MSSQL\LOGS\mastlog.ldf
2007-12-04 00:04:36.05 Server -m
2007-12-04 00:04:36.05 Server -c
2007-12-04 00:04:36.05 Server -T 3608

That is, all options should appear aligned with each other. And there
should be a space after -T.


As I said, that GUI is really really crappy. Yes, the tab says Advanced,
but it's gone out of hand.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]