Monthly Archives: November 2009

FTP Server Monitoring in IIS 6.0

Dear All
In IIS 6.0 default FTP Publishing Server does not log for Bytes Sent and Bytes Received because of which if we try to read W3C logs of FTP we will not able to get the Downloading and uploading bytes details.
To enable these fields do the following Steps
                      Right click on FTP Site
                      Click on Properties
                      Ensure that Enable Logging is checked and click on Properties button
                     Click Advanced tab
                     Select the bytes sent & bytes received check box
This will enable FTP logging along with downloading and uploading bytes details.

Thanks

Prashant Deshpande

Leave a comment

Filed under IIS, Server Application, Web/Application Server

Monitor FTP Server details on Server ( IIS 7.0)

Dear All

Please check the document to see how to monitor FTP server.

Download document

Thanks

Prashant Deshpande

2 Comments

Filed under IIS, Server Application, Web/Application Server

Delete the Locked Files

Dear All

Today I have received a call from DU team saying that they have uploaded new DLLs in one of the website on Live server and after uploading the DLLs website was not working properly.

Here the issue was not with that DLL as they have tested it on local testing server.

Actaully when we access any website it is being getting accessed from ASPNET temporary files Folder of dot.net framework.

to resolve the issue i have done following things

Please check the Video

download the software

Thanks

Prashant Deshpande

Leave a comment

Filed under IIS, Server Application, Web/Application Server

TEMPDB issue in SQL server

Dear All

Yesterday I have received call from DU team that they are getting error of TEMPDB

“The log file for database ‘tempdb’ is full. Back up the transaction log for the database to free up some log space.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.”

Here i would like to mention one note that tempdb is the very sensitive so if we do shrinking of log file it may cause data currption.

so i have used a trick , i have taken backup of tempdb on live server downloaded it on local system and attached and change the database mode in Simple and then given following command in Local SQL query analyser

 

 

 

DBCC SHRINKDATABASE tempdb TRUNCATEONLY

 

 

I got a message

“Server: Msg 2501, Level 16, State 1, Line 1 Could not find table named ‘1525580473’. Check sysobjects. “
after this I have taken backup of this local Tempdb of whcih size was reduced drastically

Again uploaded on live server and attached by stoping SQL server and then restarted SQL server of live server .

After this i got confirmation from DU team that now itw working properly and tranasactions are getting processed fastly.

Thanks

Prashant Deshpande

Leave a comment

Filed under Database Server, Server Application, SQL Server

Resolving Database IO is thawed Error

Dear All

On one of Live server following error has been shown in SQL server Activity Logs

So checked Event Viewer which was filled up of following Event

Event Source: SQLVDI
Event Category: None
Event ID: 1
Date:
Time:
User: N/A
Computer:
Description: SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller. . Process=7100. Thread=3132. Client. Instance=MSSQLSERVER

and
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date:
Time:
User: NT AUTHORITY\SYSTEM
Computer:
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [msdb] TO VIRTUAL_DEVICE='{3E291B59-2DF7-4E2E-80B2-8B7993208DEB}5′ WITH SNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024

done googling but didn’t got solution so executed the command in start–> run –>
Regsvr32 Path\SQLVDI.DLL

This command is used to set the default path of SQLVDI.exe file.

then restarted the SQL server and the issue has been resolved

Thanks

Prashant Deshpande

Leave a comment

Filed under Database Server, SQL Server

Install Windows 2003 Compatible Applications on Windows 2008

Dear All

Here we have upgraded one Windows 2003 Server to 2008 and I was trying to install Business objects on it.

While Installation it was giving error when installation wastrying to start each service of Bussines Objects

so i have checked Evenet log and following error has been shown in Event viewer
Evenet Log
by Reading this event log nothing has been cleared that becuase of which it was services are not getting started.
Please find the soultion which has resolved the issue and Bussines Object has installed and running fine.

As Bussines Obejcts XI is a Windows 2003 Comaptible Application it was giving that error

Step 1
Right click setup and select Properties

Step 2
Click in Compatibility tab

Step 3
Select Windows 2003 service pack 1 and check run as Administrator

AFter doing these steps double click on Setup. Will get installed and run smoothly.

Thanks,

Prashant Deshpande

Leave a comment

Filed under IT Support, Operating System

Enhance the Windows 7 performance

Dear All

Please check for 63 Tips to enhance Windows 7

Download Document

Thanks

Prashant Deshpande

Leave a comment

Filed under IT Support, Operating System