Backup taking TOO long after migration from SQL 2005 to SQL

Compresses, encrypts, secures and monitors SQL Server backups.

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: 2296
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: 2296
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

cron