How to shrink the log file in MS SQL?
beginer
1544
Points
52
Posts
|
I want to reduce db size. As we using more and more transaction db log file getting big. Can we reduce log file size and so that db size will be reduced. Refer following: https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/ https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-file?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-ver15 - Brian 10-Feb-2022 21:53
|
Answers
Brian
2376
Points
13
Posts
|
Refer following:
Posted On:
10-Feb-2022 21:54
|
Raj
648
Points
26
Posts
|
To shrink a data or log file
Posted On:
17-Feb-2022 21:36
|