Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1492
  • Last Modified:

Using Robocopy to move SQL Server folders and subdirectory

Hello Experts

      I am trying to use Robocopy to copy my sql server folders and subdirectory from one drive to another but not having very much luck :-(

Tree structure:

Microsoft SQL Server
       - MSSQL.1
            - MSSQL
                  - Backup
                     - Data
                        - Analysis Services
                           - Engine
                              - Integrated Samples
                                 - Integrated Services
                                    - Notification Services
                                       - Replication
                                          - Reporting Services

How would I go about doing this?

Thanks for your time today
0
algotube
Asked:
algotube
  • 2
  • 2
2 Solutions
 
Darius GhassemCommented:
0
 
serialbandCommented:
Do the /mir and /copyall options not work for you?

robocopy /mir /copyall D:\MSSQL.1 E:\MSSQL.1
0
 
algotubeAuthor Commented:
Good day sorry for the late reply crazy around here.  No I am not using Robocopy GUI edition, command line.  Yes I have to look into RichCopy looks good...
Serialband, if I use robocopy /mir /copyall D:\MSSQL.1 E:\MSSQL.1
will this copy even permissions...... ????

Thanks for getting back to me guys...........
0
 
serialbandCommented:
The /copyall option copies all permissions.  The /mir option tells it to mirror the diroctory structure.

The syntax should actually have the options after the source and destination.

robocopy D:\MSSQL.1 E:\MSSQL.1/mir /copyall
0
 
algotubeAuthor Commented:
Thank you so much for your help......very much appreciated.......
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now