[windows2000] Re: SQL Server 2K Question
- From: "Mauricio Fernandez" <mfernandez@xxxxxxxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2005 08:31:25 -0400
Open Enterprise manager, right click on the Sever and choose Properties ?
go to DATABASE SETTINGS tab and there is a place to choose the folders for
Data and log files.
There is a way to change the location of existing data files, but I prefer
to create a new DB with the files located in the new drive and copy the
data from old DB to the new one.
HIH
Mauricio Fernández S.
IT Manager
Tel. 591- 445-25160
Fax. 591- 441-15056
mfernandez@xxxxxxxxxxxxxxx
www.fdta-valles.org
Cochabamba - Bolivia
-----Original Message-----
From: windows2000-bounce@xxxxxxxxxxxxx
[mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Ron Leach
Sent: Tuesday, June 21, 2005 4:22 PM
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:
