I would use the sp_detach_db, move the file(s) using Explorer/My Computer
etc, then execute sp_attach_db pointing to new location.
Caroline.

> ----------
> From: Morgan.[Email Address Removed] Sent: 11 June 2002 15:51
> To: Chris Kempster
> Cc: SQLDBA (E-mail)
> Subject: Model Database
>
>
> Would anyone know how to modify the model database so the default path for
> the data file is D:\ and the default path for the transaction log it E:\
>
> help much apprecitated.
>
> thanks
> Morgan
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]


____________________________________________________________________
"This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. This communication may contain material protected by
attorney-client privilege. If you are not the intended recipient or
the person responsible for delivering the email to the intended
recipient, be advised that you have received this email in error and
that any use, dissemination, forwarding, printing, or copying of this
email is strictly prohibited. If you have received this email in error
please notify the IT Call Centre by telephone on 44 (0) 1953 608000."

[Email Address Removed]MS Sql Server LazyDBA home page