Hello:

I have reviewed the MSDN page on moving the system databases. But, I do not
see anywhere on that page where it is explained how to move the model
database to another location of the server (in the same instance) in SQL 2005.

Could someone please post for me here on the board how to do this?

Thanks!

childofthe1980s

Not sure which article you were looking at but this one has a section on
moving the model db.

http://support.microsoft.com/default.aspx/kb/224071

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in
message news:A9D81F75-DAB2-4DB9-9617-958C5498B550@microsoft.com...
> Hello:
>
> I have reviewed the MSDN page on moving the system databases. But, I do
> not
> see anywhere on that page where it is explained how to move the model
> database to another location of the server (in the same instance) in SQL
> 2005.
>
> Could someone please post for me here on the board how to do this?
>
> Thanks!
>
> childofthe1980s

In SQL Server 2005, the steps for moving the model database are the same as
any system database (except master and resource). Assuming this is a
planned relocation of the model database, why not use the procedure defined
under the section: Planned Relocation and Scheduled Disk Maintenance
Procedure in this topic: I'm assuming you are referring to this topic in
Books Online: http://msdn.microsoft.com/en-us/library/ms345408.aspx.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/s.../bb428874.aspx

"childofthe1980s" <childofthe1980s@discussions.microsoft.com> wrote in
message news:A9D81F75-DAB2-4DB9-9617-958C5498B550@microsoft.com...
> Hello:
>
> I have reviewed the MSDN page on moving the system databases. But, I do
> not
> see anywhere on that page where it is explained how to move the model
> database to another location of the server (in the same instance) in SQL
> 2005.
>
> Could someone please post for me here on the board how to do this?
>
> Thanks!
>
> childofthe1980s