Results 1 to 2 of 2

Thread: Move datafile

  1. #1
    Join Date
    Aug 2002
    Location
    BH - MG - BRAZIL
    Posts
    13

    Unanswered: 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 atention

  2. #2
    Join Date
    Oct 2002
    Posts
    5
    Hi,
    You can move datafiles of a DB using Detach & Attach procs..
    Search for 'sp_detachdb' eg in BOL.. its straightforward mate..

    cheers
    ganesh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •