Saturday, February 25, 2012

Move datafile

Hi,

I need to move some datafiles from E to F. These datafiles are into of the filegroups.

i.e:
Actual
FILEGROUP: CDL_DATA e CDL_IDX
DATAFILE'S: e:\data\Cdl_data.NDF e e:\data\Cdl_idx_data.NDF

Changed
FILEGROUP: CDL_DATA e CDL_IDX
DATAFILE'S: F:\data\Cdl_data.NDF e F:\data\Cdl_idx_data.NDF


Is there a easy way by Enterprise Manager that I can do this job?

Thank you by atentionHi,
You can move datafiles of a DB using Detach & Attach procs..
Search for 'sp_detachdb' eg in BOL.. its straightforward mate..

cheers
ganesh

No comments:

Post a Comment