Welcome to MSDN Blogs Sign in | Join | Help

May 2009 - Posts

Tuesday, May 26, 2009 12:44 PM

SQL Server gives error 8985 - "Could not locate file XXXXXXX in sysfiles"

Recently we came across this scenario: - A transaction log was growing fast in size. - To free up space we decided to: o Backup the transaction log o Shrink the log file to reclaim lost space from the hard disk The backup log command worked as expected,
Posted by John Daskalakis | 1 Comments
Monday, May 18, 2009 11:35 AM

Tips & Tricks for optimizing the performance of your SQL Server

Here is a collection of some tips and ideas that you can use to improve the performance of your SQL Server. I had not collected all of these tips in a single reference page till now. It’s not necessary to apply all these ideas in your environment to achieve
Posted by John Daskalakis | 6 Comments
Thursday, May 14, 2009 10:09 AM

Forefront Client Security: Application failed to initialize: 0x800106ba

Consider this scenario: - You have installed Forefront Client Security on a Windows 2000 Server - When the installation completes, the FCS service cannot start and you get error: 2147942526 - When you try to start the FCS application, you get error: Application
Posted by John Daskalakis | 11 Comments
Monday, May 11, 2009 2:20 PM

Sharepoint Error: The specified domain either does not exist or could not be contacted.

Consider this scenario: - You have installed a Sharepoint 2007 server and made it member of domain called “A”. - There is another domain called “B” that trusts domain A. - You are trying to make an Active Directory connection through Shared services administration
Posted by John Daskalakis | 2 Comments
Friday, May 08, 2009 10:13 AM

Error 12291 or 208 inside windows application log, when running a maintenance plan on SQL Server

Recently we came across a very strange issue. A customer had performed an in-place upgrade of his SQL Server 2000, to SQL Server 2005. So he was using the maintenance plans he had built through Enterprise Manager in his upgraded SQL Server 2005 server.
Posted by John Daskalakis | 8 Comments
Thursday, May 07, 2009 9:13 AM

How to rebuild the performance counters of a SQL Server 2005 or 2008 instance

Consider this scenario: - You have setup a SQL Server 2005 or 2008 - You then open the windows tool called Perfmon (Performance Monitor) and you notice that the SQL Server related performance counters are missing (or at least some of them). The missing
Posted by John Daskalakis | 7 Comments
 
Page view tracker