Howtos / Articles

‘TRUNCATE_ONLY’ is not a recognized BACKUP option in SQL 2008

In Microsoft SQL server 2000 and 2005, as part of the ‘BACKUP LOG’ command, there was an option to truncate the log file, without storing a backup to file. In Microsoft SQL Server 2008, this option has been removed, and you can now no longer use the ‘TRUNCATE_ONLY’ option when performing a transaction log backup. The truncate only option is used to truncate the log file. This is generally done so you can then shrink the transaction log file, and…

Read more [...]

How to shrink a Microsoft SQL transaction log file

The transaction log file contains a record of every transaction against the database, since the last transaction log backup. All changes in the database are first saved to the transaction log, before being updated in the main data file. The transaction log file can allow a database administrator to recover a database back to a specific point in time, rather than simply back to the last full backup. If you find there was some sort of database corruption at 4:30pm,…

Read more [...]

What is the SQL transaction log file?

A Microsoft SQL database consists of at least two files, a data file (.mdf) and a transaction log file (.ldf). The data file contains all the data for the database, as you would expect. The transaction log file contains a record of every transaction against the database, since the last transaction log backup. All changes in the database are first saved to the transaction log, before being updated in the main data file. The transaction log file can allow a…

Read more [...]