Posted by Piero 'Giops' Giorgi on 09/25/07 17:23

On Sep 25, 12:59 am, Erland Sommarskog <esq...@sommarskog.se> wrote:

> This link in Books Online should be useful:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ad9a4e92-13fb-457d-996a-66ffc2d55b79.htm

.... Am I right? (Just to be sure...)

The files NOW are in G:\CrimDB\ and I need them in F:\CrimDB\
The Filegroups are in G:\CrimDB\FileGroups

Basically I have to :

1) Detach the Database

use master
go
sp_detach_db 'crimdb'
go

---------------------------------------------------
2) manually move the two files

G:\CrimDB\CrimDB.mdf
G:\CrimDB\CrimDB_Log.ldf

to the new F:\CrimDB\Data\ path]
---------------------------------------------------

3) reattach the Database

use master
go
sp_attach_db 'mydb','F:\CrimDB\Data\CrimDB.mdf','F:\CrimDB\Data
\CrimDB_Log.ldf'
go

The Filegroups will be seen without any other change, right?
(I just want to be sure, given that the Db has 350M records, I don't
want to break it...)

Thank you!

Piero

[Back to original message]