Delete Data or Log Files from a Database [!INCLUDE SQL Server] This topic describes how to delete data or log files in [!INCLUDE ssnoversion] by using [!INCLUDE ssManStudioFull] or [!INCLUDE tsql].

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

SQL Server transaction logs A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file.

Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...

We've got a table used to log operations that gets it's data aggregated and then all it's rows deleted nightly, which I'm trying to speed up as much as possible. I think that deleting the rows is ...

I have a SQL Server database that's 145GB, about 80% of that space is occupied by "files". Staff have the ability to upload files from the web front end application into the database, this is used ...