Backup taking TOO long after migration from SQL 2005 to SQL
Hello,
We just migrated our databases from SQL 2005 to 2008 R2. It's on Active Passive cluster with a shiny new hardware. It used to take 30 minutes to backup 500 GB database on old crappy hardware. Now it takes over 6 hours and takes too much resources too. Checked everything but looks like hardware is not an issue at all.
Any immediate suggestions? Thanks in advance.
We just migrated our databases from SQL 2005 to 2008 R2. It's on Active Passive cluster with a shiny new hardware. It used to take 30 minutes to backup 500 GB database on old crappy hardware. Now it takes over 6 hours and takes too much resources too. Checked everything but looks like hardware is not an issue at all.
Any immediate suggestions? Thanks in advance.
Comments
The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.
Please send the files to peter.yeoh@red-gate.com.
Thank you.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8