Cannot move msdb/model even with -T3608

On 3 Dec, 23:04, Erland Sommarskog <esq...@.sommarskog.sewrote:
...

Quote:

Originally Posted by

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.Mike (huttm@.yahoo.co.uk) writes:

Quote:

Originally Posted by

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?

Yes, you need to do as I told you. :-) Look at my output again:

Quote:

Originally Posted by

Quote:

Originally Posted by

>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

Do you see that my hyphens are perfectly aligned, and that there is a
space after the -T? Compare to yours where the hyphens are indented
and there is no space after the -T.

Yes, the interface really sucks. I suggest that you copy the entire
startup parameters box to an editor with a fixed font, and make
sure that there are no spaces where there shouldn't be.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog (esquel@.sommarskog.se) writes:

Quote:

Originally Posted by

Yes, the interface really sucks. I suggest that you copy the entire
startup parameters box to an editor with a fixed font, and make
sure that there are no spaces where there shouldn't be.

By the way, I find the old bug that I had filed. It may help to clarify:
https://connect.microsoft.com/SQLSe...edbackID=125567
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx