[windows2000] Re: SQL Server 2K Question
- From: "Tony Lyne" <Tony.Lyne@xxxxxxxxxxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2005 08:41:04 +1200
Hi Ron,
Use this article for a reference on how to do it.
You can also do it via the Enterprise manager GUI, but I prefer to use
the Query Analyser.
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=s
ql2k
Tony Lyne (MCSE, CCEA, ASE)
Senior Systems Engineer
Computerland Central
P O Box 1470
PALMERSTON NORTH
Telephone (+64) 06 3537300
Facsimile (+64) 06 3566800
Mobile (+64) 0274 720696
E-mail Tony.Lyne@xxxxxxxxxxxxxxxxxx
Internet http://www.computerland.co.nz
<BLOCKED::http://www.computerland.co.nz/>
CAUTION: This e-mail message and accompanying data may contain
information that is confidential and subject to privilege. If you are
not the intended recipient, you are notified that any use,
dissemination, distribution or copying of this message or data is
prohibited. If you have received this e-mail in error, please notify me
immediately and delete all material pertaining to this e-mail. Thank
you.
________________________________
From: windows2000-bounce@xxxxxxxxxxxxx
[mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Ron Leach
Sent: Wednesday, 22 June 2005 8:22 a.m.
To: windows2000@xxxxxxxxxxxxx
Subject: [windows2000] SQL Server 2K Question
A previous tech had installed SQL Server 2K and put the data files on
the same drive as the program files. Is there any way to change the
drive where the data files will reside? I know when you create a new DB
that you can choose where to put the data files but I want the data
files to default to this new drive.
TIA
Ron
Other related posts:
