R
R
Ruslan Samara2019-07-07 12:52:59
Backup
Ruslan Samara, 2019-07-07 12:52:59

Why does the backup of MS SQL database over the network take a very long time?

MS SQL 2005 is used. With local backup, the backup takes about 10 minutes (base 180GB), there were no problems over the network before and the backup was performed in 40 minutes. When copying to the same remote server for storing backups, the network is loaded at 100% and everything is quickly copied, but there was a problem with backing up the database using the command:

BACKUP DATABASE [БАЗА] TO  DISK = N'E:\Пусть сетевого диска' WITH NOFORMAT, INIT,  NAME = N'Имя', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

The network is not loaded at this moment and the database is backed up for 12 hours at a speed of 4.5 Mb / s. Please tell me where to dig? Is it a matter of the user under which MSSMS is running, or is it a matter of some settings inside MSSMS?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
H
hint000, 2019-07-07
@hint000

In the first case (in 40 minutes) the following process takes place in the network: 5d2205e1cc5f8961198235.png
In the second case (in 12 hours), something like this: 5d22060ce273e917302788.pngThere is nothing surprising. This is how it works.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question