What are the challenges you face when working across database platforms? Take the survey
Options

Backup taking TOO long after migration from SQL 2005 to SQL

apatapat Posts: 3
edited April 25, 2013 12:34PM in SQL Backup Previous Versions
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.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Could you please send me the SQL Backup log for a backup that was made on the SQL 2005 instance, and another log for a backup that was made for the migrated database on the SQL 2008 R2 instance?

    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Emailed you the logs. Please let me know if you need more details.
  • Options
    peteypetey Posts: 2,358 New member
    Have you tried backing up the database using THREADCOUNT = 8, as you were previously doing on the SQL 2005 instance?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.