[windows2000] SV: Re: SQL Server 2K Question
- From: "Svein Arild Haugum" <svein@xxxxxxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Thu, 23 Jun 2005 13:27:12 +0200
Or use Query analyser
use master
go
sp_detach_db database-name
go
then move the files where you would like them
use master
go
sp_attach_db databasename,'d:\sql_logs\logile.ldf','e:\sql_Data\datafile.mdf'
go
should be a walk in the park... (Done this like 26372432 times, and it cant go
wrong...)
Mvh
Svein Arild
_____
Fra: Mauricio Fernandez [mailto:mfernandez@xxxxxxxxxxxxxxx]
Sendt: 22. juni 2005 14:31
Til: windows2000@xxxxxxxxxxxxx
Emne: [windows2000] Re: SQL Server 2K Question
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:
- » [windows2000] SV: Re: SQL Server 2K Question
