Knowledgebase
TimeTrack support > TimeTrack support > Knowledgebase

Search help:


SQL Log File

Solution

To Shrink the LOG file (LDF) please run the following command in your SQL Server

you have to check the log file name in the database properties and enter the same in this command. In the sample Log file name is TimeTrack_log

sample
ALTER DATABASE TimeTrack SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(TimeTrack_log, 1)
ALTER DATABASE TimeTrack SET RECOVERY FULL WITH NO_WAIT
GO 
 
Was this article helpful? yes / no
Related articles Primary Key
Add New Company
TTAutoOps crash - Fathcrypt
SQL Server version - Installation at Multiple PC's
ZK InBio Multi door controller
Article details
Article ID: 48
Category: SQL Server Version
Date added: 31/10/2014 13:31:56
Views: 342
Rating (Votes): Article rated 5.0/5.0 (1)

 
« Go back