Change Data folder

Hi,
we have just set up a monster of a server and installes SQL Server 2000
on it.
The server has a RAID 5 setup and we want the data to be located on the
D-drive and have set "D:\Data" as the default database and logfile
folder.
Our databases has been moved to the server/folder an attached.
The question is - shoud we/can we move the master, model tmpdb and other
default databases to the "D:\Data" folder as well?
Thankful for any sound advice here...
Bent S. Lund
System Developer
MCP VB
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Hi,
Yes, you can do that . MSDB and Model database can detached , move the MDF
to new locaton and attach it back. For master database using the enterprise
manager -- use the Startup Parameters button and you will see the entries
for master.mdf and mastlog.ldf files. There you can specify the new
location, stop sql server service, copy tboth the files to new location and
start the SQL Server service.
Details are given in the below link:-
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default...b;EN-US;224071
Thanks
Hari
MCDBA
"Bent Lund" <bstlu@.online.no> wrote in message
news:OOoJJbmYEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi,
> we have just set up a monster of a server and installes SQL Server 2000
> on it.
> The server has a RAID 5 setup and we want the data to be located on the
> D-drive and have set "D:\Data" as the default database and logfile
> folder.
> Our databases has been moved to the server/folder an attached.
> The question is - shoud we/can we move the master, model tmpdb and other
> default databases to the "D:\Data" folder as well?
>
> Thankful for any sound advice here...
> Bent S. Lund
> System Developer
> MCP VB
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
|||On Mon, 05 Jul 2004 01:05:05 -0700, Bent Lund <bstlu@.online.no> wrote:

>Hi,
>we have just set up a monster of a server and installes SQL Server 2000
>on it.
>The server has a RAID 5 setup and we want the data to be located on the
>D-drive and have set "D:\Data" as the default database and logfile
>folder.
>Our databases has been moved to the server/folder an attached.
>The question is - shoud we/can we move the master, model tmpdb and other
>default databases to the "D:\Data" folder as well?
>
>Thankful for any sound advice here...
>
There are different procedures for master, model, tempdb and user
databases see this article
http://support.microsoft.com/default...b;en-us;224071
Regards
Chris
|||would definately think about where tempdb is depending on what your usage
patterns are - used heavily for GROUP BY , sorting etc . You may benefit
from keeping tempdb I/O seperate to other I/O (ie your D: drive). KB
article below talks about tempdb usage as well as a hotfix that reduces
contention (only apply if you see issues). Also see Books Online "Optimizing
tempdb performance"
http://support.microsoft.com/default...b;en-us;328551
Webcast
http://support.microsoft.com/default...b;en-us;834846
cheers,
Andy.
"Bent Lund" <bstlu@.online.no> wrote in message
news:OOoJJbmYEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi,
> we have just set up a monster of a server and installes SQL Server 2000
> on it.
> The server has a RAID 5 setup and we want the data to be located on the
> D-drive and have set "D:\Data" as the default database and logfile
> folder.
> Our databases has been moved to the server/folder an attached.
> The question is - shoud we/can we move the master, model tmpdb and other
> default databases to the "D:\Data" folder as well?
>
> Thankful for any sound advice here...
> Bent S. Lund
> System Developer
> MCP VB
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thanks all!
The server is now running with all databases on the raid-disk setup.
One thing - when using Query Analyzer to detach/attach databases I ouf
course made a typing error...
I was happy to find out that startup parameters could be changed in the
registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters
Thanks again!
regards
Bent S. Lund
System Developer
MCP VB
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Change Data folder

Hi,
we have just set up a monster of a server and installes SQL Server 2000
on it.
The server has a RAID 5 setup and we want the data to be located on the
D-drive and have set "D:\Data" as the default database and logfile
folder.
Our databases has been moved to the server/folder an attached.
The question is - shoud we/can we move the master, model tmpdb and other
default databases to the "D:\Data" folder as well?
Thankful for any sound advice here...
Bent S. Lund
System Developer
MCP VB
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Hi,
Yes, you can do that . MSDB and Model database can detached , move the MDF
to new locaton and attach it back. For master database using the enterprise
manager -- use the Startup Parameters button and you will see the entries
for master.mdf and mastlog.ldf files. There you can specify the new
location, stop sql server service, copy tboth the files to new location and
start the SQL Server service.
Details are given in the below link:-
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
Thanks
Hari
MCDBA
"Bent Lund" <bstlu@.online.no> wrote in message
news:OOoJJbmYEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi,
> we have just set up a monster of a server and installes SQL Server 2000
> on it.
> The server has a RAID 5 setup and we want the data to be located on the
> D-drive and have set "D:\Data" as the default database and logfile
> folder.
> Our databases has been moved to the server/folder an attached.
> The question is - shoud we/can we move the master, model tmpdb and other
> default databases to the "D:\Data" folder as well?
>
> Thankful for any sound advice here...
> Bent S. Lund
> System Developer
> MCP VB
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||On Mon, 05 Jul 2004 01:05:05 -0700, Bent Lund <bstlu@.online.no> wrote:
>Hi,
>we have just set up a monster of a server and installes SQL Server 2000
>on it.
>The server has a RAID 5 setup and we want the data to be located on the
>D-drive and have set "D:\Data" as the default database and logfile
>folder.
>Our databases has been moved to the server/folder an attached.
>The question is - shoud we/can we move the master, model tmpdb and other
>default databases to the "D:\Data" folder as well?
>
>Thankful for any sound advice here...
>
There are different procedures for master, model, tempdb and user
databases see this article
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
Regards
Chris|||would definately think about where tempdb is depending on what your usage
patterns are - used heavily for GROUP BY , sorting etc . You may benefit
from keeping tempdb I/O seperate to other I/O (ie your D: drive). KB
article below talks about tempdb usage as well as a hotfix that reduces
contention (only apply if you see issues). Also see Books Online "Optimizing
tempdb performance"
http://support.microsoft.com/default.aspx?scid=kb;en-us;328551
Webcast
http://support.microsoft.com/default.aspx?scid=kb;en-us;834846
cheers,
Andy.
"Bent Lund" <bstlu@.online.no> wrote in message
news:OOoJJbmYEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi,
> we have just set up a monster of a server and installes SQL Server 2000
> on it.
> The server has a RAID 5 setup and we want the data to be located on the
> D-drive and have set "D:\Data" as the default database and logfile
> folder.
> Our databases has been moved to the server/folder an attached.
> The question is - shoud we/can we move the master, model tmpdb and other
> default databases to the "D:\Data" folder as well?
>
> Thankful for any sound advice here...
> Bent S. Lund
> System Developer
> MCP VB
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

Change Data folder

Hi,
we have just set up a monster of a server and installes SQL Server 2000
on it.
The server has a RAID 5 setup and we want the data to be located on the
D-drive and have set "D:\Data" as the default database and logfile
folder.
Our databases has been moved to the server/folder an attached.
The question is - shoud we/can we move the master, model tmpdb and other
default databases to the "D:\Data" folder as well?
Thankful for any sound advice here...
Bent S. Lund
System Developer
MCP VB
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Hi,
Yes, you can do that . MSDB and Model database can detached , move the MDF
to new locaton and attach it back. For master database using the enterprise
manager -- use the Startup Parameters button and you will see the entries
for master.mdf and mastlog.ldf files. There you can specify the new
location, stop sql server service, copy tboth the files to new location and
start the SQL Server service.
Details are given in the below link:-
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/defaul...kb;EN-US;224071
Thanks
Hari
MCDBA
"Bent Lund" <bstlu@.online.no> wrote in message
news:OOoJJbmYEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi,
> we have just set up a monster of a server and installes SQL Server 2000
> on it.
> The server has a RAID 5 setup and we want the data to be located on the
> D-drive and have set "D:\Data" as the default database and logfile
> folder.
> Our databases has been moved to the server/folder an attached.
> The question is - shoud we/can we move the master, model tmpdb and other
> default databases to the "D:\Data" folder as well?
>
> Thankful for any sound advice here...
> Bent S. Lund
> System Developer
> MCP VB
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||On Mon, 05 Jul 2004 01:05:05 -0700, Bent Lund <bstlu@.online.no> wrote:

>Hi,
>we have just set up a monster of a server and installes SQL Server 2000
>on it.
>The server has a RAID 5 setup and we want the data to be located on the
>D-drive and have set "D:\Data" as the default database and logfile
>folder.
>Our databases has been moved to the server/folder an attached.
>The question is - shoud we/can we move the master, model tmpdb and other
>default databases to the "D:\Data" folder as well?
>
>Thankful for any sound advice here...
>
There are different procedures for master, model, tempdb and user
databases see this article
http://support.microsoft.com/defaul...kb;en-us;224071
Regards
Chris|||would definately think about where tempdb is depending on what your usage
patterns are - used heavily for GROUP BY , sorting etc . You may benefit
from keeping tempdb I/O seperate to other I/O (ie your D: drive). KB
article below talks about tempdb usage as well as a hotfix that reduces
contention (only apply if you see issues). Also see Books Online "Optimizing
tempdb performance"
http://support.microsoft.com/defaul...kb;en-us;328551
Webcast
http://support.microsoft.com/defaul...kb;en-us;834846
cheers,
Andy.
"Bent Lund" <bstlu@.online.no> wrote in message
news:OOoJJbmYEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi,
> we have just set up a monster of a server and installes SQL Server 2000
> on it.
> The server has a RAID 5 setup and we want the data to be located on the
> D-drive and have set "D:\Data" as the default database and logfile
> folder.
> Our databases has been moved to the server/folder an attached.
> The question is - shoud we/can we move the master, model tmpdb and other
> default databases to the "D:\Data" folder as well?
>
> Thankful for any sound advice here...
> Bent S. Lund
> System Developer
> MCP VB
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Thanks all!
The server is now running with all databases on the raid-disk setup.
One thing - when using Query Analyzer to detach/attach databases I ouf
course made a typing error...
I was happy to find out that startup parameters could be changed in the
registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\Parameters
Thanks again!
regards
Bent S. Lund
System Developer
MCP VB
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!