Upgrading SQL instance containing compressed databases

Silent data compression to optimize SQL Server Storage

Moderators: eddie davis, Colin Millerchip, fionag

Upgrading SQL instance containing compressed databases

Postby epetro » Thu Jan 05, 2012 9:04 pm

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.
epetro
 
Posts: 55
Joined: Tue May 31, 2011 7:55 pm
Location: Zotec Partners

Postby eddie davis » Mon Jan 09, 2012 12:25 pm

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Success

Postby epetro » Mon Jan 09, 2012 1:53 pm

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.
epetro
 
Posts: 55
Joined: Tue May 31, 2011 7:55 pm
Location: Zotec Partners

Postby eddie davis » Mon Jan 09, 2012 4:42 pm

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Storage Compress 6

Who is online

Users browsing this forum: No registered users and 0 guests