cancel
Showing results for 
Search instead for 
Did you mean: 

Backing up SQL Database with BE 2014

Vdang
Level 4

Hello Guys,

I hope someone can answer this question for me and that is from within BE 2014 with the option to backup the database using the "Full - Back up Databases" method, does it also back up the transcation log or would be require to create a secondary job for log backup.

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified

You need another job to backup and truncate the transaction logs.  See my article below

https://www-secure.symantec.com/connect/articles/how-backup-sql-logs-and-truncate-them-be-2012

Although this is written for BE 2012, it is equally valid for BE 2014.

View solution in original post

3 REPLIES 3

pkh
Moderator
Moderator
   VIP    Certified

You need another job to backup and truncate the transaction logs.  See my article below

https://www-secure.symantec.com/connect/articles/how-backup-sql-logs-and-truncate-them-be-2012

Although this is written for BE 2012, it is equally valid for BE 2014.

Vdang
Level 4

PKH,

How would I know if the transaction log has been properly backup after the job have been created. Is there a way to check? 

pkh
Moderator
Moderator
   VIP    Certified
Check that the job is successful