Backup taking TOO long after migration from SQL 2005 to SQL

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Backup taking TOO long after migration from SQL 2005 to SQL

Postby apat » Tue Apr 23, 2013 6:56 pm

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.
apat
 
Posts: 2
Joined: Tue Apr 23, 2013 6:52 pm

Postby petey » Thu Apr 25, 2013 7:07 am

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 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm

Postby apat » Thu Apr 25, 2013 2:06 pm

Emailed you the logs. Please let me know if you need more details.
apat
 
Posts: 2
Joined: Tue Apr 23, 2013 6:52 pm

Postby petey » Thu Apr 25, 2013 5:34 pm

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 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests