How to back up SQL transaction logs
|Article:HOWTO73853|||||Created: 2012-03-02|||||Updated: 2012-03-16|||||Article URL http://www.symantec.com/docs/HOWTO73853|
Use the Log No Truncate method only when the database is corrupted or database files are missing. This method backs up transactions that you may not be able to access otherwise when the database is in this state. You can then use this transaction log backup along with the last database backup and any previous transaction log backups to restore the database to the point at which it failed; however, any uncommitted transactions are rolled back. The Log No Truncate method does not remove committed transactions after the log is backed up.
To use the Log No Truncate backup to restore a database, you should also have a database backup that was created before the Log No Truncate backup. The transaction log contains only the log files used in the restore process, which alone are not sufficient to restore a complete database. You must have at least one database backup and a log backup of the database to restore a database.
Article URL http://www.symantec.com/docs/HOWTO73853