Working on a database project today I got the latest drop from a co-worker to test on our deployment machine. The process had gone on without a hitch for the past few months but today the SQL 2005 database backup file he gave me would not restore on the deployment machine...gave an error during the restore saying it was "INCOMPLETE". A quick check of SQL Server versions using MS KB 321185 showed us that he was on SQL 2005 SP3 and I was on SQL 2005 SP2. Thankfully that 2 minutes worth of checking ......
SQL Saturday #9 scheduled for this year on October 11, in Greenville, SC is looking for speakers. If you are interested let me know and I'll get you plugged in.
For more information visit: http://www.sqlsaturday.com/eventhome.aspx?eventid=12
Disclaimer – this article describes a fix that worked for me – YMMV…proceed with caution. I recently encountered a weird error with the TFSWarehouse data cube and reporting services for our site. It started out innocently enough with an error I hadn’t seen before in the event log (shown below) Well that was odd enough because it suddenly appeared out of nowhere, but then I also noticed odd things going on with the reports that TFS generates. It was generating reports but it was all stale data…apparently ......
Due to some sweeping changes that are coming down the pipeline at work I've got to change IP's for a number of SQL clusters that are in production. Having gone through enough nightmares while originally setting up these clusters over the years I wasn't looking forward to it... but since I had enough lead time I took some lab assets to mirror the production setup so I could play with it before crunch time. I'm posting the following reference to a Microsoft KB article for my own benefit and for those ......
And equally important - is it recommended? Has anyone else out there successfully clustered SQL 2000/2005 together? I've seen stuff out there that says it works and other stuff that says it doesn't. I'm actually about to scrape up some hardware to try it out because the topic came up at work, just wanted some additional insight before making that plunge. The end result we're after is to have an Active/Passive Windows 2003 cluster that has a SQL 2000 instance and a SQL 2005 instance on it...more to ......