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.
one of the main tweaks was to disable IPv6 on the 2008 NIC, also the SMB2.0 issue can be addressed by shutting it down, but you would normally do this to a client system such as Win 7 when accessing 200/2003
The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately.
This Article and the Links apply to…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software.
Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012.
Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…