We have a server running windows server 2008 SP2 standard which has MS SQL server 2005 installed with some small SQL databases. Our backups are intermittently taking a long time to run. And there doesn’t appear to be any particular pattern to the issue.
We are using the Symantec backup exec system recover 2010 software with a scheduled backup at 9pm in the evening to image all the drives and often the backup doesn’t finish until 11:00am or even later in the following day. Even if we just backup the system drive which doesn’t have much data apart from the operating system then the backup still doesn’t finish until 2 -2:30am in the morning.
We have also tried to use the inbuilt windows backup software but backups still sometimes take a long time to run. If we reboot the server and then the next scheduled backup runs faster (backups usually finish of all drives by 2-2:30am in the morning which is what we would expect) but then a few days later we will get the same slow backup issue. When the backups are running the server’s memory usage is very high (often 95%) but the processor usage is low (around 5%) and it looks like SQL is using most of the memory so perhaps a software configuration on SQL server 2005 is the problem?. All disks have plenty of free disk space.
The below shows the servers disk allocation:
#1.1 C SYSTEM DISK Size: 50Gb
W2008 Operating system
#1.2 E Applications Size: 415Gb
#2 F OtherData Size: 465Gb
Any help on how to resolve this issue would be great.