MS SQL Server - Change of default path while creating New DB

Author

Change of default path while creating New DB

Herbert

2005-04-01, 7:01 am

Hi,

while creating new database and setting the Data and Log file by
default it shows the default path (based on SQL Server Installation) .

If we want to change the path we will be able to change. But while creating
Data and Log file i want the the default path it shows to some other default
path.

Please give me the solution as early as possible

Thanks,
Herbert

Mike Epprecht (SQL MVP)

2005-04-01, 7:01 am

Hi

Enterprise Manager
Click on the Server
Right click
Select properties
Database Settings Tab
Change the values 2/3 of the way down the page "new database default
location".

From that point onwards, new databases created use those paths.

Regards
Mike

"Herbert" wrote:

> Hi,
>
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
>
> If we want to change the path we will be able to change. But while creating
> Data and Log file i want the the default path it shows to some other default
> path.
>
> Please give me the solution as early as possible
>
> Thanks,
> Herbert

Ray D

2005-04-01, 7:01 am

server propeties->database settings->def. data&log dir?
I think this settings stored somewhere in the registry.

"Herbert" wrote:

> Hi,
>
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
>
> If we want to change the path we will be able to change. But while creating
> Data and Log file i want the the default path it shows to some other default
> path.
>
> Please give me the solution as early as possible
>
> Thanks,
> Herbert

Hari Prasad

2005-04-01, 7:01 am

Hi,

CHange the value for the below registry keys.

For a SQL 2000 default instance, the default folders are stored in the
registry under:

HKEY_LOCAL_MACHINE\S
OFTWARE\Mi_crosoft\M
SSQLServer\MSSQLServ
er\DefaultData
HKEY_LOCAL_MACHINE\S
OFTWARE\Mi_crosoft\M
SSQLServer\MSSQLServ
er\DefaultLog

For named Instance:

HKEY_LOCAL_MACHINE\S
OFTWARE\Mi_crosoft\M
icrosoft SQL Server\[Instance
Name]\MSSQLServer\De
faultData
HKEY_LOCAL_MACHINE\S
OFTWARE\Mi_crosoft\M
icrosoft SQL Server\[Instance
Name]\MSSQLServer\De
faultLog

Enterprise Manager:-
These can be viewed/changed with Enterprise Manager (server properties -->
database settings). This will also update the registry.

Thanks
Hari
SQL Server MVP

"Herbert" <Herbert@discussions.microsoft.com> wrote in message
news:95A73C48-62BB-4264-B121- 2D3FB8D4E4D7@microso
ft.com...
> Hi,
>
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
>
> If we want to change the path we will be able to change. But while
> creating
> Data and Log file i want the the default path it shows to some other
> default
> path.
>
> Please give me the solution as early as possible
>
> Thanks,
> Herbert

Sponsored Links