SQL Server log data is very important for any DBA to troubleshoot SQL Server related problems. In SQL Server 2000 there was no facility to check System and Application log, however in SQL Server 2005 there is facility of the log viewer. It is very useful tool and very easy to use as well. In SQL [...]...

If SQL Server is running slow and operations are throwing errors due to lack of memory, it is necessary to look into memory issue. If SQL Server is restarted all the cache memory is automatically cleaned up. In production server it is not possible to restart the server. In this scenario following three commands can [...]...

ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. If you receive above error it means you are in great trouble. This error occurs when database is attempted to attach and it does not get attached. [...]...

Ahmedabad SQL Server User Group is just 2 months old chapter but it is getting extremely popular among enthusiastic IT professionals. I have joined this group and suggest all the developers of Ahmedabad and surrounding areas to join this group. It does not matter which application you are using but SQL Server is same everywhere. Ahmedabad [...]...

Just two day ago, I wrote small note about SQL SERVER - Introduction to Service Broker. Yesterday I wrote article where Service Broker throws error due to it is using same port as other application SQL Server - Fix - Error : 9692 The _MSG protocol transport cannot listen on port because it is in use [...]...