cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft SQL Backup

staningrimsby
Level 4
Please excuse me if I am missing something but is there any documentation on how to backup SQL2012 database ?? I have look through the admin manual but cant seem to find it anywhere ? I believe that in addition to my full daily backup I have to set up a second one that just backs up the SQL databases but would like to look at some documentation first. I already have the applications and databases add on installed as well.
3 REPLIES 3

VJware
Level 6
Employee Accredited Certified

A second backup job (in addition to the full backup) is needed if you intend on making differential backups or transaction log backups.

Have a look @ the best practices for agent for sql as well - http://www.symantec.com/business/support/index?page=content&id=HOWTO74429

Sush---
Level 6
Employee Accredited Certified

Hello there,

    You just need to create a new job and select the SQL databases to be backed up through the Microsoft SQL Instance node in the job selection list. You can also add the same in your daily backup.

http://www.symantec.com/docs/HOWTO74429 : Best practices for Backup Exec 2012 Agent for Microsoft SQL Server

 

Regards,

-Sush...

CraigV
Moderator
Moderator
Partner    VIP    Accredited

Hi,

 

The Admin Guide is going to have all you need to know around setting up and running backups of SQL.

Here's the Best Practices too:

http://www.symantec.com/business/support/index?page=content&id=HOWTO74429

Thanks!