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

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...