« Oracle Database Patching Just Got More Complicated | Main | Attacks on Oracle Databases Get Even Simpler »
Microsoft SQL Server Upgrade Woes: 2005 to 2008
By Eric Gross | July 20, 2009
Is your restore taking a long time?
A common upgrade methodology used in a MSSQL environment is backup/restore. If you choose to use this method and you are upgrading from MSSQL 2005 to MSSQL 2008 you should consider applying the most recent update (MSSQL Cumulative Update 4 for the base release or MSSQL Cumulative Update 1 for SP1) because if you don’t, the restore operation will take up to 10x as long as you expect it to take. Alternatively you could choose to use the detach/attach route which would not be affected by this particular bug.
Assuming you’re using automation software, you’ll want to add this to your comprehensive preflight checklist which exists to confirm that the operation that you are about to perform has all of its prerequisites met.
Details on Microsoft’s website
Topics: Uncategorized