file in is server what is a log file in sql server To add a log file to the database use the ADD LOG FILE clause of the ALTER DATABASE statement. It keeps a record of everything do… Friday, June 24, 2022 Edit