Posted by Mike on 12/07/07 12:44

On 3 Dec, 23:04, Erland Sommarskog <esq...@sommarskog.se> wrote:
....
> 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.
>

Thank you for your reply.

I have done as you suggested, and now my errorlog shows the following:

2007-12-07 12:36:37.33 Server Registry startup parameters:
2007-12-07 12:36:37.33 Server -d D:\MSSQL\DATA\master.mdf
2007-12-07 12:36:37.33 Server -e D:\MSSQL\LOG\ERRORLOG
2007-12-07 12:36:37.33 Server -l C:\MSSQL\LOGS\mastlog.ldf
2007-12-07 12:36:37.33 Server -m
2007-12-07 12:36:37.33 Server -c
2007-12-07 12:36:37.33 Server -T3608

However, when I do an exec sp_detach msdb, I still get the error
message saying "System databases master, model, msdb, and tempdb
cannot be detached.".

Is there something else I need to do?

Mike.

• Next in forum: question regarding slow performance an PAGEIOLATCH_SH locks on sql 2005
• Prev in forum: Re: Managing multiple queries
• Thread view: Re: Cannot move msdb/model even with -T3608

[Reply to this message]