Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (6.1k points)
I want to empty an LDF file before sending to a co-worker. What do I do to force the SQL Server to truncate the log?

1 Answer

0 votes
by (12.7k points)

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.

Related questions

0 votes
1 answer
0 votes
2 answers
0 votes
1 answer
asked Dec 19, 2020 in SQL by Appu (6.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...