2

I'm planning to move the log files for the databases ReportServer, ReportServerTempDB, tempDB, and msdb to a new drive. But it seems that permissions aren´t copied with the directories and files; should I bother to move them over? (Or is that overkill?)

1 Answer 1

1

If you don't move the permissions too the service account under which SQL Server is running may not be able to access them.

You can use Robocopy to do this quite easily. I tend to use the following.

ROBOCOPY <source> <target> /MIR /SEC /SECFIX

More detaisl on this command can be found here

More Robocopy options can be found here

2
  • Does ROBOCOPY /MIR <Source> <Target> copy both the file and the permissions or just copy the permissions to an existing file?
    – Peter
    Jan 29, 2016 at 11:07
  • I have updated the command to cover the updating of security on files you have already copied. Jan 29, 2016 at 11:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.