SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

published 655 days, 13 hours, 30 minutes ago posted by

sa 664 days, 15 hours, 34 minutes ago

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

This was the question asked by a developer, due to a particular process fills up the transaction log so quickly. I had to explain the reason and tricks that can reduce the transaction log bulge using best recovery methods on the database. Going back to basics there certain FAQ about Transaction log usage within SQL Server. Transaction Log - why it is required? A log is a seperate file that stores all kinds of information about the SQL Server instance and databases. Each database has its own log file...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: Best Practices, DBA, disk space, free space, log writer, size, SQL Server, transactionon log, vlf

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up