SQL Backup job with backup Exec

Hi Experts,

I make my SQL backups with BackupExec 2014.
For a fully backup of the SQL Databases what is the best way.
I have FULL and INCREMENTAL and LOG backups.

When I backup the full SQL Instance, is it also needed to backup the mdf and ldf files ?
Eprs_AdminSystem ArchitectAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark WillsTopic AdvisorCommented:
use sql server to create the backups. easy to schedule and then backupexec can do the physical copy of the backup files to avoid any locking conflicts or exclusive access (yes, backup exec is meant to be sql friendly, but the tools are readily available within sql server for creating DB backups).

you will always need a FULL backup and that does both the transaction log (ldf) and database file (mdf).

you will always need LOG backups at regular intervals (depends on your DR plan as to frequency - maybe hourly).

log backups are crucial with FULL RECOVERY DB's (default recovery model) for point in time recovery and to keep the transaction log healthy.

questionable if differential / incremental backups are required. Typically only on large DB's where a part of the DB is highly active to cut down time spent doing FULL backups.

But if you have time overnight, then best to do FULL each night then hourly transaction log backups during the day.

Have a read of : http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/A_657-Managing-the-Transaction-Log-for-the-Accidental-DBA.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brendt HessSenior DBACommented:
Depending on how busy your system is, you may want a different backup strategy. For example, the backups on the main databases where I work consist of a Full backup every night, log backups every 15 minutes, and an incremental backup every 4 to 6 hours.

The incremental backup is very useful if you have frequent log backups.  An incremental backup is a snapshot of everything that has changed in the database since the last full backup, whereas a log backup is a record of all of the changes since the last full backup, incremental backup, or log backup.  So, if it has been 20 hours since your last full backup and you have a failure, you could restore 20 log files, or (assuming every six hour incremental backups) one incremental backup and two log backups.  This is even better with every 15 minute log backups such as we use.  At 20 hours out, we have 80 log backups to restore, or one incremental backup and 7 log backups.  Personally, I know which one I would prefer to use.

mark willis is correct - use SQL Server to make the backups onto a local drive, then Backup Exec to backup to tape, external disk arrays,  or whatever destination you choose.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.