Please can anyone tell me how I can change the default
location of the data folder for SQL2000?
For example it's currently
C:\Program Files\Microsoft SQL Server\MSSQL\Data
I want to change it so that each time a user creates a
database or a backup, the default location for the file to
be created is:
D:\MSSQL\
Can you help?
Thank youFrom Enterprise Mangler, right click the server name, select PROPERTIES.
Choose the Database Settings tab. Near the bottom are the fields for
default database and log file locations.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Val" <anonymous@.discussions.microsoft.com> wrote in message
news:062501c3fae3$6c570bb0$a501280a@.phx.gbl...
> Please can anyone tell me how I can change the default
> location of the data folder for SQL2000?
> For example it's currently
> C:\Program Files\Microsoft SQL Server\MSSQL\Data
> I want to change it so that each time a user creates a
> database or a backup, the default location for the file to
> be created is:
> D:\MSSQL\
> Can you help?
> Thank you|||I found it - apologies
Knowledge base 272705
To change:
Right click your instance, SQL Server Properties, Database
settings tab, enter the location you want eg
D:\MSSQL
If only they were all so easy.|||Val
The default data directory is determined at the time SQL Server was
installed.
create database test
on
primary ( name=test,
filename='d:\my_test.mdf',
size=100mb,
maxsize=200,
filegrowth=20)
LOG on
(
name=test1,
filename='d:\my_test.ldf',
size=100mb,
maxsize=200,
filegrowth )
"Val" <anonymous@.discussions.microsoft.com> wrote in message
news:062501c3fae3$6c570bb0$a501280a@.phx.gbl...
> Please can anyone tell me how I can change the default
> location of the data folder for SQL2000?
> For example it's currently
> C:\Program Files\Microsoft SQL Server\MSSQL\Data
> I want to change it so that each time a user creates a
> database or a backup, the default location for the file to
> be created is:
> D:\MSSQL\
> Can you help?
> Thank you|||there is some sort of bug when you try and do this - you
cannot save the default location all the time.
>--Original Message--
>From Enterprise Mangler, right click the server name,
select PROPERTIES.
>Choose the Database Settings tab. Near the bottom are
the fields for
>default database and log file locations.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Val" <anonymous@.discussions.microsoft.com> wrote in
message
>news:062501c3fae3$6c570bb0$a501280a@.phx.gbl...
>> Please can anyone tell me how I can change the default
>> location of the data folder for SQL2000?
>> For example it's currently
>> C:\Program Files\Microsoft SQL Server\MSSQL\Data
>> I want to change it so that each time a user creates a
>> database or a backup, the default location for the
file to
>> be created is:
>> D:\MSSQL\
>> Can you help?
>> Thank you
>
>.
>
Showing posts with label folder. Show all posts
Showing posts with label folder. Show all posts
Thursday, March 22, 2012
Change default data folder for MSSQL2000
Please can anyone tell me how I can change the default
location of the data folder for SQL2000?
For example it's currently
C:\Program Files\Microsoft SQL Server\MSSQL\Data
I want to change it so that each time a user creates a
database or a backup, the default location for the file to
be created is:
D:\MSSQL\
Can you help?
Thank youFrom Enterprise Mangler, right click the server name, select PROPERTIES.
Choose the Database Settings tab. Near the bottom are the fields for
default database and log file locations.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Val" <anonymous@.discussions.microsoft.com> wrote in message
news:062501c3fae3$6c570bb0$a501280a@.phx.gbl...
> Please can anyone tell me how I can change the default
> location of the data folder for SQL2000?
> For example it's currently
> C:\Program Files\Microsoft SQL Server\MSSQL\Data
> I want to change it so that each time a user creates a
> database or a backup, the default location for the file to
> be created is:
> D:\MSSQL\
> Can you help?
> Thank you|||Val
The default data directory is determined at the time SQL Server was
installed.
create database test
on
primary ( name=test,
filename='d:\my_test.mdf',
size=100mb,
maxsize=200,
filegrowth=20)
LOG on
(
name=test1,
filename='d:\my_test.ldf',
size=100mb,
maxsize=200,
filegrowth=20
)
"Val" <anonymous@.discussions.microsoft.com> wrote in message
news:062501c3fae3$6c570bb0$a501280a@.phx.gbl...
> Please can anyone tell me how I can change the default
> location of the data folder for SQL2000?
> For example it's currently
> C:\Program Files\Microsoft SQL Server\MSSQL\Data
> I want to change it so that each time a user creates a
> database or a backup, the default location for the file to
> be created is:
> D:\MSSQL\
> Can you help?
> Thank you|||there is some sort of bug when you try and do this - you
cannot save the default location all the time.
>--Original Message--
>From Enterprise Mangler, right click the server name,
select PROPERTIES.
>Choose the Database Settings tab. Near the bottom are
the fields for
>default database and log file locations.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Val" <anonymous@.discussions.microsoft.com> wrote in
message
>news:062501c3fae3$6c570bb0$a501280a@.phx.gbl...
file to
>
>.
>
location of the data folder for SQL2000?
For example it's currently
C:\Program Files\Microsoft SQL Server\MSSQL\Data
I want to change it so that each time a user creates a
database or a backup, the default location for the file to
be created is:
D:\MSSQL\
Can you help?
Thank youFrom Enterprise Mangler, right click the server name, select PROPERTIES.
Choose the Database Settings tab. Near the bottom are the fields for
default database and log file locations.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Val" <anonymous@.discussions.microsoft.com> wrote in message
news:062501c3fae3$6c570bb0$a501280a@.phx.gbl...
> Please can anyone tell me how I can change the default
> location of the data folder for SQL2000?
> For example it's currently
> C:\Program Files\Microsoft SQL Server\MSSQL\Data
> I want to change it so that each time a user creates a
> database or a backup, the default location for the file to
> be created is:
> D:\MSSQL\
> Can you help?
> Thank you|||Val
The default data directory is determined at the time SQL Server was
installed.
create database test
on
primary ( name=test,
filename='d:\my_test.mdf',
size=100mb,
maxsize=200,
filegrowth=20)
LOG on
(
name=test1,
filename='d:\my_test.ldf',
size=100mb,
maxsize=200,
filegrowth=20
)
"Val" <anonymous@.discussions.microsoft.com> wrote in message
news:062501c3fae3$6c570bb0$a501280a@.phx.gbl...
> Please can anyone tell me how I can change the default
> location of the data folder for SQL2000?
> For example it's currently
> C:\Program Files\Microsoft SQL Server\MSSQL\Data
> I want to change it so that each time a user creates a
> database or a backup, the default location for the file to
> be created is:
> D:\MSSQL\
> Can you help?
> Thank you|||there is some sort of bug when you try and do this - you
cannot save the default location all the time.
>--Original Message--
>From Enterprise Mangler, right click the server name,
select PROPERTIES.
>Choose the Database Settings tab. Near the bottom are
the fields for
>default database and log file locations.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Val" <anonymous@.discussions.microsoft.com> wrote in
message
>news:062501c3fae3$6c570bb0$a501280a@.phx.gbl...
file to
>
>.
>
Monday, March 19, 2012
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!
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!
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!
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!
Thursday, February 16, 2012
Catching errors in SSIS Backup Database Task
Hi,
In my SSIS package, I have a backup database task. When I run the package with DestinationAutoFolderPath set to a folder ("Network Service" account has full permission on this folder) and DestinationCreationType set to Auto, the task works just fine creating a backup with its own name. (similar to database_date<count>).
But what I want is in my front-end I am allowing the user to specify the name of the backup file. So I want the task to create the backup file in the name I supply. I set the DestinationCreationType to manual and in the application code added the DestinationManualList with the path from the UI.
Now the pacakge runs fine but does not take any backup. There is no errors as well. If I set the FailPackageOnFailure and FailParentOnFailure to true, then I am getting the DTSExecResult.Failure but I am not getting the actual error from the backup database task.
Am I missing anything here?
Thanks in advance,
Srikanth.
How are you executing the package?
What does the logfile (I assume that you have one) say?
-Jamie
|||
Thanks a lot for the reply.
I enabled the log in package and the backup database task. The following is the text appears in the log file:
#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnPreValidate,SERVER211,SERVER211\Administrator,DICoreDataPackage,{8B470140-EB79-4A15-A2A7-10590065310C},{844D2D28-16D8-42C8-9E1F-3E1506544BE5},8/29/2006 11:31:28 AM,8/29/2006 11:31:28 AM,0,0x,(null)
PackageStart,SERVER211,SERVER211\Administrator,DICoreDataPackage,{8B470140-EB79-4A15-A2A7-10590065310C},{844D2D28-16D8-42C8-9E1F-3E1506544BE5},8/29/2006 11:31:28 AM,8/29/2006 11:31:28 AM,0,0x,Beginning of package execution.
Diagnostic,SERVER211,SERVER211\Administrator,DICoreDataPackage,{8B470140-EB79-4A15-A2A7-10590065310C},{844D2D28-16D8-42C8-9E1F-3E1506544BE5},8/29/2006 11:31:28 AM,8/29/2006 11:31:28 AM,0,0x,Based on the system configuration, the maximum concurrent executables are set to 3.
OnPreExecute,SERVER211,SERVER211\Administrator,DICoreDataPackage,{8B470140-EB79-4A15-A2A7-10590065310C},{844D2D28-16D8-42C8-9E1F-3E1506544BE5},8/29/2006 11:31:28 AM,8/29/2006 11:31:28 AM,0,0x,(null)
PackageEnd,SERVER211,SERVER211\Administrator,DICoreDataPackage,{8B470140-EB79-4A15-A2A7-10590065310C},{844D2D28-16D8-42C8-9E1F-3E1506544BE5},8/29/2006 11:31:29 AM,8/29/2006 11:31:29 AM,1,0x,End of package execution.
The thing is, I configured the DestinationCreationType to "manual" and added my backup file name through coding to DestinationManualList ArrayList:
if (backupTask.DestinationManualList == null)
backupTask.DestinationManualList = new ArrayList();
backupTask.DestinationManualList.Add(m_SSISArgs.DatabaseBackupPath);
The objective is to create backup of the database with the file name I am giving. Do I have to set anyother property for this...
Subscribe to:
Posts (Atom)