Browse by Tags

• Database Administration
• SQL Server 2008
• Upgrades

• Diskeeper 2010 Update

  A few weeks ago I blogged about A tale of CHECKDB failures caused by 3rd party file-system drivers that was related to a bug in the latest version of Diskeeper 2010.  I received an email from the company that they have released an update that resolves Read More... Posted Tuesday, December 29, 2009 2:32 PM by Jonathan Kehayias | 2 Comments Filed under: Error Messages, Database Administration

• SQL Server 2008 failed installation blocks Service Pack 1 (SP1) installation

  While building a Virtual Machine tonight to do some testing and screenshots for a future article/blog post, and possibly for a presentation, I ran into a problem installing SQL Server 2008 on Windows Server 2008.  For whatever reason, during installation Read More... Posted Friday, September 04, 2009 2:21 AM by Jonathan Kehayias | 5 Comments Filed under: Error Messages, SQL Server 2008

• SQL Server 2008 Evaluation Edition Expiration Woes

  With SQL Server 2008 passing its 6 months since RTM date, a common problem is popping up in the forums and is now listed on Connect .  When an install of Evaluation Edition Expires, the services stop functioning until an upgrade is made to a full Read More... Posted Friday, February 20, 2009 11:13 AM by Jonathan Kehayias | 41 Comments Filed under: Error Messages, Upgrades, SQL Server 2008

• Setup Failure: Performance Counter Last Value Check (SQL Server 2005)

  I happened to have the need to go back after the fact and add Integration Services to a Server.  The server has been in production use for almost two years now and one of our new applications needed an Integration Services package to load data from Read More... Posted Monday, February 09, 2009 1:42 PM by Jonathan Kehayias | 5 Comments Filed under: Error Messages

• SQL Server 2008 Change Data Capture: Msg 22830, Level 16, State 1

  I was working with Change Data Capture this weekend and I happened upon a interesting problem while configuring the AdventureWorks2008 database for CDC. I was working on my laptop in a disconnected state from the Active Directory Domain that my windows Read More... Posted Sunday, February 01, 2009 8:56 AM by Jonathan Kehayias | 0 Comments Filed under: Error Messages

• Error: 945, Severity: 14, State: 2 | Database 'mssqlsystemresource' cannot be opened

  This is a somewhat continuation post from my post Error: 5123, Severity: 16, State: 1 when moving TempDB . So breaking my laptops SQL Instance and then fixing it got me interested in how else could I break SQL Server and make it not start up. I recalled Read More... Posted Thursday, January 22, 2009 8:21 AM by Jonathan Kehayias | 9 Comments Filed under: Error Messages

• Error: 5123, Severity: 16, State: 1 when moving TempDB

  I have seen the problem for this post twice in the forums in the last month and both times the way it was fixed was not documented as supported method, though in a desperate "production down" scenario I probably would have done the same thing Read More... Posted Tuesday, January 06, 2009 8:15 AM by Jonathan Kehayias | 3 Comments Filed under: Error Messages

• Understanding 'login failed' (Error 18456) errors in SQL Server 2005

  One of my favorite errors that I get paged for is the login failed (error 18456). I have a few users who are guaranteed to ping me at least once or twice a week for a failed login. Generally I can tell that the user is simply trying to login to the wrong Read More... Posted Tuesday, March 04, 2008 10:24 AM by Jonathan Kehayias | 0 Comments Filed under: Error Messages