SQL Server News & Information tsql, performance tuning, industry trends, & bad jokes
tsql, performance tuning, industry trends, & bad jokes
This site is maintained by Jason Massie. He has 10 years experience as a DBA and has specialized in performance tuning for the last five. He was recognized by Microsoft as a SQL Server MVP. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. He has worked at Terremark (formerly Data Return) for nearly a decade.
You can contact him at jason@statisticsio.com or 469.569.5965
Abstracts addition Affinity Aggregation allocation Always Analysis Announced another API Appending article Authentication backup be Behavior between Bootstrapper Breaking Build Cache Caching Check checksums Codeplex collection Connecting contest Controller Creating CTEs CTP CUBE cursors Data Database DATALENGTH Debugging Design Diagnosing Diagnostic Differences Documentation DTS Emergency enhancement Entity ETW Exchange execution Express Extensions Fall February Filestream Filtered group GROUPING have Hosting Idle impact Improvement Increase Index Indexes Inserts Instances Interoperability Introduction IO large Late LOB local Localized Magazine Maintaining Maintenance Management maps March Microsoft minutes missing Mix Never November Offline OLE Online operations operators optimizations Optimized Overlapping Package Page Paging Panacea parallel part Partial Partition partitioned Partitioning PASS Performance PFS plan Plans Practices problem Problems Procedure Program programmatically Programming Protection Queries query read recent Recursive Related released Reports Restore return ROLLUP ROWCOUNT Runtime Security Select Sequence sequential Server Services set SETS Shooting shorts sizes Solutions Sortable SPARSE Spool SQL SQLIOSim SSIS Stalled Star Statement Statements stats Stored strategy Stuck Studio Submission Subreports Suggested Summarizing system Table Tables Tampa Task Than there through Timeouts Total Traces Transaction transfer Tricks Trouble TSQL turning understand Understanding undocumented Unique unused upgrade Upgrading Useful Value variables VDI Vista Will Windows Wireless
So if you have been following me on Twitter or ran across my thread on MSDN, you know I have been trying to get rolling upgrades to SQL Server 2008 working. I got it to work this morning. A SQL Server 2008 upgrade with a couple of seconds of downtime. Booyah.
The idea is to setup database mirroring between two SQL Server 2005 instances. Run the SQL Server 2008 upgrade on the mirror instance and then failover the principal.
After failover you get these messages:
2008-04-07 11:44:11.83 spid25s Converting database 'test01' from version 611 to the current version 643.2008-04-07 11:44:11.83 spid25s Database 'test01' running the upgrade step from version 611 to version 621.<snip>2008-04-07 11:44:12.42 spid25s Database 'test01' running the upgrade step from version 641 to version 642.
and, of course, mirroring cannot resync with SQL Server 2005.
"'TCP://JMASSI-00033004.drtn.corp:5022', the remote mirroring partner for database 'test01', encountered error 948, status 2, severity 20. Database mirroring has been suspended. Resolve the error on the remote server and resume mirroring, or remove mirroring and re-establish the mirror server instance."
There are other considerations like updating stats, functionality testing, external objects like jobs that you might want to take the down time for but sometimes up time is more important.
Name (required)
Email (required)
Website
Notify me of followup comments via e-mail