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