Do SQL Server Logs get Backed Up? 1

[JohnBates]

hi all,

When we perform a Backup Database for the system databases, does that also backup the Agent log? Agent.out

I'm thinking that these logs never get backed up because they are outside of any database.

Thanks, john

 

[calico]

Hi,

Those files (Agent log and Agent.out) are outside of any database and those files must be backup with other toll like NT backup, backup-exec, etc...

Only the transaction-log of a database can be backuped by "BACKUP LOG" sql statement.

Calico