SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Life without model
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 07/28/2002 :  16:20:31  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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

United Kingdom
313 Posts

Posted - 07/29/2002 :  03:40:29  Show Profile  Visit VyasKN's Homepage  Reply with Quote
Good one Jasper. No wonder Microsoft has the following note in Q224071

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.

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page

jasper_smith
SQL Server MVP & SQLTeam MVY

United Kingdom
846 Posts

Posted - 07/29/2002 :  14:38:19  Show Profile  Visit jasper_smith's Homepage  Reply with Quote
Cheers Vyas
Its 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.

HTH
Jasper Smith
Go to Top of Page

VyasKN
SQL Server MVP & SQLTeam MVY

United Kingdom
313 Posts

Posted - 07/29/2002 :  17:18:34  Show Profile  Visit VyasKN's Homepage  Reply with Quote
Probably that feature is inherited from Sybase ;-)
Hopefully they'll correct it in Yukon.

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page

Tim
Starting Member

Australia
392 Posts

Posted - 08/04/2002 :  20:30:01  Show Profile  Reply with Quote
hey my database is named "Super Model" - we affectionatley call it "Claudia"

Go to Top of Page

robvolk
Most Valuable Yak

USA
15657 Posts

Posted - 08/07/2002 :  13:14:35  Show Profile  Visit robvolk's Homepage  Reply with Quote
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

Go to Top of Page

VyasKN
SQL Server MVP & SQLTeam MVY

United Kingdom
313 Posts

Posted - 08/07/2002 :  14:42:01  Show Profile  Visit VyasKN's Homepage  Reply with Quote
That was a pretty interesting discussion ;-)

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page

Tim
Starting Member

Australia
392 Posts

Posted - 08/07/2002 :  20:08:55  Show Profile  Reply with Quote
Rob: DBA's are from Mars, databases are from Venus

----
Nancy Davolio: Best looking chick at Northwind 1992-2000
Go to Top of Page

rburtoff
Starting Member

USA
1 Posts

Posted - 02/28/2007 :  08:36:31  Show Profile  Reply with Quote
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.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000