Query to truncate log files or shrink all MS SQL Databases
Submitted by
Divya
on
Execute the following query to shrink and truncate log files of all the databases in the instance.
Forums
Description
Hardware, Software, OS Troubleshooting
Truncate MS SQL Database Log file
Submitted by
Divya
on
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
Forums
Repair MS SQL Corrupted or Suspected Database
Submitted by
Divya
on
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
Forums
How to delete short-cuts in pen-drive created by virus?
Submitted by
Divya
on
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?
Forums
Why pendrive not shows full capacity as specified?
Submitted by
Divya
on
Hard disk, pen drive, flash drives, memory cards showing less capacity comparing to the specification provided by the manufacturer.
What's the reason for it?
How to utilize full capacity?
My 16 GB pen drive shows 14.9 GB only..
Forums
Difference between 2nd Generation and 3rd Generation Laptops, Processors
Submitted by
sureshdurairaj80
on
What is the difference between 2nd Generation & 3rd Generation Processors / Laptops?
Forums
What is the difference between DDR, DDR2 and DDR3?
Submitted by
Ramakrishnan
on
What is the difference between various RAM Modules currently used? i.e., DDR, DDR2, DDR3?
Forums
Difference between Online UPS and Offline UPS
Submitted by
kumar
on
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
Forums
Difference Between LED, LCD and TFT
Submitted by
mkrkarthi2011
on
What is the difference between LED, LCD and TFT displays?
Forums
Increase speed of your Internet band width
Submitted by
Karthik
on
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.
Forums