| Author |
Message |
epetro
Joined: 31 May 2011
Posts: 55
Location: Zotec Partners
|
 Posted: Thu Jan 05, 2012 9:04 pm Post subject: Upgrading SQL instance containing compressed databases |
 |
|
Looks like I will be upgrading an instance of SQL 2005 from SP3 CU10 to SP4 CU3 tomorrow morning.
Unlikely, but if someone sees this between now and then and has information to issues/resolutions/workarounds that they have experienced or discussed, please add to this thread.
I will probably play it safe and take the databases OFFLINE and bring them back ONLINE individually after a final reboot. |
|
| Back to top |
|
 |
eddie davis
Joined: 14 Jun 2006
Posts: 796
Location: Red Gate Software
|
| Posted: Mon Jan 09, 2012 12:25 pm Post subject: |
|
|
Hi,
Thank you for your post into the forum and for alerting to me to the fact that we have no Knowledge Base articles giving advice on the actions required on upgrading SQL Server instances when you have compressed database's configured.
Your proposed action of taking the databases off-line and bringing them back on-line after the final re-boot is the best course of action.
We have a KB article on upgrading SQL Storage Compress that recommends this action when upgrading SQL Storage Compress when compressed databases are already present or in-use, which can be viewed using this LINK.
Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com |
|
| Back to top |
|
|
epetro
Joined: 31 May 2011
Posts: 55
Location: Zotec Partners
|
| Posted: Mon Jan 09, 2012 1:53 pm Post subject: Success |
|
|
The upgrade to SP4 was successful.
I had SQL related issues with CU3, completely unrelated to Redgate...so I ditched that plan and am comfortable on SP4.
The databases actually came back ONLINE faster than expected. |
|
| Back to top |
|
|
eddie davis
Joined: 14 Jun 2006
Posts: 796
Location: Red Gate Software
|
| Posted: Mon Jan 09, 2012 4:42 pm Post subject: |
|
|
Excellent news that your upgrade was successful.
With the release of SQL Storeage Compress V6 / HyperBac Components V5.4.1.5, improvements were made to increase the performance and reliability when bringing databases back on line. Good to hear that these improvements worked out for you.
Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com |
|
| Back to top |
|
|
|
|
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
