Hardware & Troubleshooting

Description

Hardware, Software, OS Troubleshooting

Truncate MS SQL Database Log file

Submitted by Divya on Thu, 20/04/2017 - 18:35

Large size of log file can be truncated using the below command. Make sure to take backup if log file is necessary. Replace the database name 'test' and log file name 'test_log' in the below below query then execute.

USE test
GO
ALTER DATABASE test SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(test_log,1)
ALTER DATABASE test SET RECOVERY FULL WITH NO_WAIT
GO

How to delete short-cuts in pen-drive created by virus?

Submitted by Divya on Sat, 31/05/2014 - 17:31

Recently my pen-drive affected by Virus.

I have done through scanning using Latest antivirus.

Now all the files and folders are in hidden state. 

I have enabled the hidden files using the steps provided in the post : Enable hidden files and folders in pen-drive 

Now, How to delete the shortcuts that are in pendrive?

Difference between Online UPS and Offline UPS

Submitted by kumar on Fri, 02/03/2012 - 21:05

Offline UPS

Offline UPS supply grid power to electrical and electronic devices during normal power supply. It switches to battery power only during power failures and other power problems. As the grid power is bypassed to the load during normal power supply, it is known as Offline UPS. As the UPS is used only during power problems it is also known as Standby UPS. Offline UPS is also spelled as Off-Line UPS or Off Line UPS.
Apart from bypassing power to the load, Offline UPS also

Increase speed of your Internet band width

Submitted by Karthik on Sun, 09/01/2011 - 21:04

Start > Run > type gpedit.msc
You will see [Local Computer Policy]
Expand the [Administrative Templates] branch
Expand the [Network] branch
Highlight [QoS Packet Scheduler]
Double-click [Limit Reservable Bandwidth]
Check [Enabled]
Change [Bandwidth limit %] to 0 %
Click [Apply] [OK]
Restart
Now, enjoy the speed of your internet!

It boosted speed of internet in my pc double time.