What is the command to truncate a SQL Server log file?

Question

1 Answer

0 votes

1 answer

asked Jan 1, 2021 in SQL by Appu (6.1k points)

0 votes

1 answer

asked Jul 15, 2019 in AWS by Amyra (12.9k points)

0 votes

1 answer

asked Dec 22, 2020 in SQL by Appu (6.1k points)

0 votes

1 answer

asked Jul 11, 2019 in Python by ParasSharma1 (19k points)

0 votes

1 answer

asked Dec 19, 2020 in SQL by Appu (6.1k points)

Mano · Answer 1 · 2021-01-02T12:42:26+0000

If I am now wrong... in query analyzer or equivalent:

BACKUP LOG  databasename  WITH TRUNCATE_ONLY

DBCC SHRINKFILE (  databasename_Log, 1)

Are you looking for a good SQL tutorial? Register to this SQL Course fast and get certified.