Archive for September, 2011

Path of Eventlog File in Windows

The Event Log files on windows are stored at %SystemRoot%\system32\config\ or C:\WINDOWS\system32\config

AppEvent.Evt

SysEvent.Evt

SecEvent.Evt

Internet Explorer.evt

How to Block a particular IP from accessing website in IIS 6.0

Open IIS manager , right click on the website which you want to block for a particular IP , click the directory security Tab , In the IP address and domain name restrictions option click edit , click add , in the type select single computer and  add the IP address which you want to block from accessing the website .

 

 

The log scan number passed to log scan in database ‘master’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

While restarting the MS SQL service you will get an error and MS SQL service on the server wont start . If you check the eventviewer  you will get the following  event logs

The log scan number passed to log scan in database ‘master’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

This usually occurs when the master.mdf or the mastlog.ldf gets corrupt . In order to solve the issue goto the following path

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL  , there you will find a  folder ” Template Data ” , copy the master.mdf and  mastlog.ldf  and replace it in

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder .

Thats it . Now  start the MS SQL service and you are done .

 

 

 

(adsbygoogle = window.adsbygoogle || []).push({}); //--> Feedjit Flag Counter