| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-28 : 16:20:31
|
| This article is based on INF: Moving SQL Server Databases to a New Location with Detach/Attach (Q224071). During the process of testing this process on a test server and moving the model and msdb databases a "funny" thing happened, the model database "disappeared". Here's what happened and why and how SQL Server dealt with the loss. Moving the system databases might be required when adding new disks or external arrays to your server or reconfiguring the RAID strategy. Article Link. |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-07-29 : 03:40:29
|
| Good one Jasper. No wonder Microsoft has the following note in Q224071NOTE: 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.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-29 : 14:38:19
|
| Cheers VyasIts odd how deeply hardcoded the name model is when all that seems to determine it is its dbid and yet it can't recognise the fact that the database attached at dbid 3 is not in fact model and raise an error.HTHJasper Smith |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-07-29 : 17:18:34
|
| Probably that feature is inherited from Sybase ;-)Hopefully they'll correct it in Yukon.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
Tim
Starting Member
392 Posts |
Posted - 2002-08-04 : 20:30:01
|
| hey my database is named "Super Model" - we affectionatley call it "Claudia" |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-07 : 13:14:35
|
And to further re-interpret the meaning of the article title, "Life Without Model", I suppose we could ask Mr. David Copperfield, Billy Joel, Donald Trump and Johnny Depp what it's like to be without their former runway bunnies  No groaning! It's not as bad as this one:http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=5126 |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-08-07 : 14:42:01
|
| That was a pretty interesting discussion ;-)--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
Tim
Starting Member
392 Posts |
Posted - 2002-08-07 : 20:08:55
|
| Rob: DBA's are from Mars, databases are from Venus----Nancy Davolio: Best looking chick at Northwind 1992-2000 |
|
|
|
rburtoff
Starting Member
1 Post |
Posted - 2007-02-28 : 08:36:31
|
Thank you, thank you, THANK YOU for the comprehensive post on this "Missing Model" topic. I ran into this problem this morning and had no clue on what went wrong.You saved me a reinstall. I beat my forehead upon the ground at your feet. |
|
|
|
|
Article: Life without model