SQL and file server migration

Discussion in 'Server Migration' started by Henry, Jul 8, 2004.

  1. Henry

    Henry Guest

    Hi All,

    I m going to perform a SQL server migration to new server with many reports
    and application located on the same server. For SQL server part, testing was
    performed and no concern so far. But for the reports and applications with
    ACL, I feel headache in the steps of migrating such stuff to new server
    since the new server will use the old server name after migration. after i
    migrate all the file w/o acl to new server, rename server and then join
    domain. any tools to help to restore those acl of each folder and files? (it
    gots over 100G of files with complex permission setting)

    Thank you very much in advance
     
    Henry, Jul 8, 2004
    #1
    1. Advertisements

  2. Hi Henry,

    Thanks for your posting here.

    Do you mean that you will copy the files to the new server and want to
    restore the ACLs as before?

    You can try to use Robocopy with the /SEC switch to copy NTFS permissions
    when copying files to the same location on the target server. This will
    ensure that both the folder structures and their NTFS permissions are fully
    copied the target server.

    Note: To refresh security information for existing destination files and
    directories without copying file data, we can use the /SECFIX switch.
    /SECFIX copies permissions for newly copied files and refreshes security
    information for existing destination files and directories.

    Refer to the following article:

    323275 How to Use Robocopy to Copy Security Information Without Copying Any
    http://support.microsoft.com/?id=323275

    You can get this utility from Windows 2000 resource kit and Windows Server
    2003 resource kit.

    Have a nice day!

    Regards,
    Bob Qin
    Product Support Services
    Microsoft Corporation

    Get Secure! - www.microsoft.com/security

    ====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    ====================================================
    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Bob Qin [MSFT], Jul 8, 2004
    #2
    1. Advertisements

  3. Hi Bob,

    How if I copy it w/o joining the domain?
    Since I need to perform both file migration with permission and use the
    original server name.
    i m facing a problem that...

    join domain + file copy = new server name
    filecopy + change name + join domain = no permission

    do u get my meaning?

    Thanks for answering
    Henry
     
    Henry Frederick, Jul 8, 2004
    #3
  4. Hi Henry,

    Are the ACLs set for domain users?

    If so, when you copy the files with permissions to anther server, the
    permissions will not lost even you change server name and join domain.

    You can test it in a lab network.

    Regards,
    Bob Qin
    Product Support Services
    Microsoft Corporation

    Get Secure! - www.microsoft.com/security

    ====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    ====================================================
    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Bob Qin [MSFT], Jul 9, 2004
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.