DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  
David Overton's Blog » All Tags » SQL Server » SBS 2008 » SQL Server 2008 (RSS)

Browse by Tags

  • SQL 2005 to SQL 2008 forklift upgrade resulted in 50% cpu utilisation (& resolution) – aka SBS 2003 to SBS 2008 SQL Application Move

    I’ve recently moved the database behind DavidOverton.com (also uksbsguy.com) from a Windows Server 2003 system with SQL 2005 to Windows Server 2008 with SQL 2008.  This would be the same process if you were potentially performing a migration from SBS 2003 with SQL 2005 to SBS 2008 Premium with SQL 2008 (or SQL 2005, but the performance issue only happens with SQL 2008). The process was amazingly simple: Stop the database on the Windows 2003 system Copy the datafiles, errorlogs, logs etc to the new system Install SQL 2008 on the new system, creating an instance by the same name Modify the registry to point to my new files (details here ) Start SQL 2008 Obviously I had to do some IIS stuff (create a new site) and install and redirect my logging software (WhosOn), but overall it went very well. Or so I thought until I noticed that my normally nominal CPU utilisation had gone bananas.  One of the SQL 2008 new and improved features is the Server Activity History which makes it very easy to pinpoint problems...

  • SBS 2008 now available for download on MSDN

    Hi there folks, so following on from my recent post on the fact that SBS 2008 has released to manufacturing (which means it will be in the shops soon), I saw today that SBS 2008 is now available to download from MSDN : I did notice that there is currently a slight mis-print in that it appears there are two disks for the x86 Windows Server 2008 disk, where as the 2nd one is actually the x64 disk (as noted in the ISO number).   It is also worth stating that for SBS 2008, to remove any issues around “Compatibility”, for those applications that are fussy, simply run them on the premium server which is Server 2008, so runs anything that you could run on Server 2008.   Go grab if you can’t wait to get it any other way … note that you only need disk 1 to install, but the rest to understand recovery and Premium solutions.   Thanks David Technorati Tags: SBSC , SBS , Small Business Server 2008 , Small Business , Developer , MSDN , Partners , Microsoft , Download , SBS 2008

  • Small Business Server 2008 (formally known as Cougar) announcement

    Today is the start of the Server 2008 PR ramp up. I can today tell you a bit more about Cougar, as was, or SBS 2008 as it will be, the new "family" that SBS is part of and a bit more on Windows Essential Business Server 2008 (aka Centro). Hopefully there will be a couple of surprises and also confirmation of some of the rumours around there. I've sliced the press release made today into 3 sections. This blog entry is based on the SBS 2008 section of which there is an extract below of some key points. The whole press release can be found at http://www.microsoft.com/presspass/press/2008/feb08/02-20EBFamilyPR.mspx . Windows Small Business Server 2008 Multiplies Business Growth Windows Small Business Server 2008,previously known by the code name “Cougar,” is ideal for organizations with up to 50 PCs, helping them protect business data, expand business productivity and present a professional image to customers. The new version adds a range of features and capabilities to the current, award-winning Small...

(c)David Overton 2006-23