model database "lost"

When moving the sysdatabases to a different drive using specific Q224071 ()
instructions i found that the model db does not show up and when running:
use model
go
sp helpfile
go
i get:
Could not locate entry in sysdatabases for database model. No entry found
with that name. Make sure that the name is entered correctly.
any ideas?Did you enable trace flag 3608 and reattach model database before msdb?
The proper steps are:
1. moving master
2. moving model
3. moving msdb
4. moving tempdb
-oj
"Christian Castro" <ChristianCastro@.discussions.microsoft.com> wrote in
message news:59F5AFE2-A996-46BF-8E53-B4D19480836B@.microsoft.com...
> When moving the sysdatabases to a different drive using specific Q224071
> ()
> instructions i found that the model db does not show up and when running:
> use model
> go
> sp helpfile
> go
> i get:
> Could not locate entry in sysdatabases for database model. No entry found
> with that name. Make sure that the name is entered correctly.
> any ideas?
>|||Hi,
Was sp_attach_db statement successfull? And did you try to remove -T3608
flag from the startup parameter?
If you have done the above, try to re-start the server and see what the
error log has to say.
Thanks
Yogish|||In addition tot he other posts, check the dbid for model (in sysdatabases).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Christian Castro" <ChristianCastro@.discussions.microsoft.com> wrote in mess
age
news:59F5AFE2-A996-46BF-8E53-B4D19480836B@.microsoft.com...
> When moving the sysdatabases to a different drive using specific Q224071 (
)
> instructions i found that the model db does not show up and when running:
> use model
> go
> sp helpfile
> go
> i get:
> Could not locate entry in sysdatabases for database model. No entry found
> with that name. Make sure that the name is entered correctly.
> any ideas?
>|||flag 3608 yes, it was enabled.
About the steps you mentioned, i followed Q224071 and it has the order like
these:
1. moving msdb
2. moving master
3. moving model
4. moving tempdb
Could you confirm where you got your order?
"oj" wrote:

> Did you enable trace flag 3608 and reattach model database before msdb?
> The proper steps are:
> 1. moving master
> 2. moving model
> 3. moving msdb
> 4. moving tempdb
>
> --
> -oj
>
> "Christian Castro" <ChristianCastro@.discussions.microsoft.com> wrote in
> message news:59F5AFE2-A996-46BF-8E53-B4D19480836B@.microsoft.com...
>
>|||No attach wasnt successful. End up with error:
Could not locate entry in sysdatabases for database model. No entry found
with that name. Make sure that the name is entered correctly.
"Yogish" wrote:

> Hi,
> Was sp_attach_db statement successfull? And did you try to remove -T3608
> flag from the startup parameter?
> If you have done the above, try to re-start the server and see what the
> error log has to say.
> --
> Thanks
> Yogish|||Make sure you attached them in the right order, I had a similar issue where
msdb became model (as well as msdb) because of a typo when attaching the
model database, led to some odd behaviour :-)
Life without model
http://www.sqlteam.com/item.asp?ItemID=10060
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Christian Castro" <ChristianCastro@.discussions.microsoft.com> wrote in
message news:59F5AFE2-A996-46BF-8E53-B4D19480836B@.microsoft.com...
> When moving the sysdatabases to a different drive using specific Q224071
> ()
> instructions i found that the model db does not show up and when running:
> use model
> go
> sp helpfile
> go
> i get:
> Could not locate entry in sysdatabases for database model. No entry found
> with that name. Make sure that the name is entered correctly.
> any ideas?
>|||It's clearly stated that model must be attached before msdb in kb 224071.
The actually order for master/tempdb is not that important when you're
moving system databases.
Moving the MSDB database (SQL Server 2000)
Note If you are using this procedure in conjunction with moving the msdb and
model databases, the order of reattachment must be model first and then
msdb. If msdb is reattached first, it must be detached and not reattached
until after model has been attached.
-oj
"Christian Castro" <ChristianCastro@.discussions.microsoft.com> wrote in
message news:C3F4F8D7-135E-4113-9423-92566B6BE454@.microsoft.com...[vbcol=seagreen]
> flag 3608 yes, it was enabled.
> About the steps you mentioned, i followed Q224071 and it has the order
> like
> these:
> 1. moving msdb
> 2. moving master
> 3. moving model
> 4. moving tempdb
> Could you confirm where you got your order?
> "oj" wrote:
>