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
Execute the below query by replacing the 'test' with the database name.
EXEC sp_resetstatus 'test'
ALTER DATABASE test SET EMERGENCY
DBCC CheckDB ('test')
ALTER DATABASE test SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('test', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE test SET MULTI_USER
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
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.
