Tuesday 18 December 2018

Reduced or SHRINK .ldf file of the sql database

////////////////////

DBCC SHRINKFILE (N'.ldf file logincal Name' , 1)


DBCC SHRINKFILE (N'Test_log' , 1)

Steps : 
1.     Select your database
2.     Right click and go to property of the databases
3.     select tab files
4.     Check your database .ldf file name (Scroll right and check last column)
5.     Copy ldf file from column Logical Name and Execute. 






No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...