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?)
Add a comment |
1 Answer
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
- Does
ROBOCOPY /MIR <Source> <Target>copy both the file and the permissions or just copy the permissions to an existing file?Peter– Peter2016-01-29 11:07:24 +00:00Commented Jan 29, 2016 at 11:07 - I have updated the command to cover the updating of security on files you have already copied.James Anderson– James Anderson2016-01-29 11:18:53 +00:00Commented Jan 29, 2016 at 11:18