Re: Default Data/Log File Directory

From: Richard Wells (Wells_at_discussions.microsoft.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 08:03:02 -0700

After moving the Master, Model, MSDB and Tempdb databases I still found that
a new DB created through DTS was still placed in the old location.

I found that the Master database location within the (Master) Sysdatabases
table was for the old path. Correcting the location resolved my problem.

 (Direct modification to system tables isn’t allowed unless you start SQL
using the -m option. BOL Search: Allow Updates Option / Administering SQL
Server)

Hope this helps!!

"Mike Vanecek" wrote:

> On Thu, 9 Sep 2004 05:59:46 +0100, Allan Mitchell wrote:
> > It would be incorrect to say that.
>
> > http://www.databasejournal.com/features/mssql/article.php/3379901
>
> It is nice to be incorrect and still receive a benefit. Thank you.
>
> --
> Thanks, Mike.
>
>

Relevant Pages