The log file for data xyz is full backup transaction log for the database to free up some log space

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

timhun Newbie Points: 4 More actions · Answer 1

run the following code:

backup log XXX with truncate_only

GO

dbcc shrinkdatabase ('XXX')

GO

Where XXX is the name of your database.