Answer the question
In order to leave comments, you need to log in
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
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question