Answer Posted / Pawan Kumar
You cannot manually clear the transaction log file in SQL Server. Instead, it automatically grows and shrinks as necessary based on transaction activity. To manage the size of the log files, you can set up maintenance plans or use scripts to perform regular backups and shrink the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different SQL Server Versions you have worked on?
Can we do dml on views?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How do I create a trace in sql server?
what is the difference between openrowset and openquery?
What kind of problems occurs if we do not implement proper locking strategy?
How raid can influence database performance?
Can you index views?
How to rebuild the master database?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are the different types of subquery?
What is a coalesce function?
What is an indexed view?
Disadvantages of the indexes?
What are the kinds of subquery?
