July 17, 2006 at 9:56 am
We have upgraded the hardware for a SQL Server. After installing SQL Server 2000 SP 3a, I restored Master which brought back my security logins. Master, msdb and model on the original server were on the D drive, so we have moved the master and msdb to the c drive. How do I move model? When I try to restore it I get an error that says it can be moved. The D drive that was set up to get around the problem is temporary and there will not be a d drive going forward. The question is how to I move model from the D drive to the C drive?
Thanks for any help
Steve
July 17, 2006 at 11:01 am
Read:
http://msdn2.microsoft.com/en-us/library/ms345408.aspx
Moving System Databases
The first query in this article applies to all system databases except for Master and Resource, follow the instructions in the article.
If it does not help then you may create a local DFS (Distributed File System) pointing to a folder as drive D. Read:
Create a DFS root
Regards,Yelena Varsha
July 17, 2006 at 1:44 pm
The article you posted although interesting is for SQL Server 2005. Is there anything like it for 2000?
Steve
July 17, 2006 at 2:55 pm
I think it is similar. You may also try this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server
Scroll one third down till the title "Moving the model database" , there are instructions for all 3 versions.
Regards,Yelena Varsha
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply