Skip to Content
0
Former Member
Nov 08, 2010 at 10:08 AM

Full Database Backup

51 Views

Hi people,

I´ve the next doubt about the backups of MS SQL Server.

If I make a full database backup, the transaction log (SIDLOG1) are backed? Or I´ve to do the backup of transactional log separated?

In the note Note 44449 - Backup strategies with the SQL server, says this:

"If you run a complete database backup, the contents of the transaction log are saved (database dump), but the log is not shortened. The transaction log is only shortened when you save the log (transaction dump)."