November 17, 2010 at 8:37 pm
In SQL2000, when moving model and msdb to different drives, is it necessary to start SQL in single user mode? Most articles i have read say to start SQL with the T3608 parameter, however others say to use -c -m -T3608. What is really necessary? Thanks in advance.
November 17, 2010 at 10:02 pm
Yes it is necessary to use 3608 trace flag. This article[/url] in SSC has good information about moving system databases.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 17, 2010 at 11:00 pm
Thank you for your quick response. I understand that T3608 must be used, however my question is whether or not the -m parameter should be specified along with it?
November 18, 2010 at 1:14 am
SQL Server should be started in Single User mode. Hence the -m startup parameter should be used
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply