Red Gate forums :: View topic - Backup taking TOO long after migration from SQL 2005 to SQL
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Backup taking TOO long after migration from SQL 2005 to SQL

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
apat



Joined: 23 Apr 2013
Posts: 2

PostPosted: Tue Apr 23, 2013 6:56 pm    Post subject: Backup taking TOO long after migration from SQL 2005 to SQL Reply with quote

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.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Thu Apr 25, 2013 7:07 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
apat



Joined: 23 Apr 2013
Posts: 2

PostPosted: Thu Apr 25, 2013 2:06 pm    Post subject: Reply with quote

Emailed you the logs. Please let me know if you need more details.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Thu Apr 25, 2013 5:34 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group