question

techresearch7777777-7743 avatar image
0 Votes"
techresearch7777777-7743 asked techresearch7777777-7743 answered

Copying files negative impacts on active SQL Server?

Hello, I have one folder that holds all of our SQL Server .bak backup files and aiming to set up a daily job to copy this folder and all files to another different server disk location.

This folder is pretty large and say it takes 1 hour to finish copying.

During this 1 hour of copying will it affect performance or any other things to be aware-concern on the current active SQL Server?...should it be done off hours?

Thanks in advance.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @techresearch7777777-7743,

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

During this 1 hour of copying will it affect performance

Of course it will, copying files causes a lot of disk I/O and network traffic; no action is for free in term of resources.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @techresearch7777777-7743,

During this 1 hour of copying will it affect performance or any other things to be aware-concern on the current active SQL Server?


Yes, as Olaf mentioned that it will cause a lot of I/O and network traffic.

should it be done off hours?

Yes, you are right. Suggest you do this off work.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

techresearch7777777-7743 avatar image
0 Votes"
techresearch7777777-7743 answered

Thanks for all the replies, much appreciated.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.