What is internal processing of "Backup Exec Microsoft SQL Server Agent"?

Question

What is internal processing of "Backup Exec Microsoft SQL Server Agent"?
	Is it SQL Server Standard Utility?
	
	There is one server.
	This server have SQL Database.
	And, we set backup using "SQL Server Standard Backup Utility" by "SQL Server Management Studio".
	This setting is "Full Backup" every day.
	
	We will install Backup Exec to this server.
	Our require of backup is...
	&nbsp; - Full Backup on Sunday
	&nbsp; - Diff Backup on Monday - Saturday
	
	If the internal processing "Backup Exec Microsoft SQL Server Agent" is "SQL Standard Utility", we cannot satisfy the requirement of *1.
	
	I want to know the internal processing of "Backup Exec Microsoft SQL Server Agent".

pkh · Accepted Answer

BE will call the SQL Server API when it is backing up SQL Server databases.&nbsp; I don't understand what you meant by "we cannot satisfy the requirement of *1."

takaratta · Answer

&gt; &nbsp; - Diff Backup on Monday - Saturday
&nbsp;
This means Differencial Backup from Sunday of being backed up by BE.

takaratta · Answer

I'm sorry, *1 means as follows
	
	&gt; Our require of backup is...
	&gt;&nbsp;&nbsp; - Full Backup on Sunday
	&gt;&nbsp;&nbsp; - Diff Backup on Monday - Saturday

For your information,

I have already set 'Full Backup Every Day at 20:00' by SQL Server Management Studio.
	
	And, I will set 'Full Backup on Sunday at 23:00' and 'Diff Backup on Monday to Saturday at 23:00'.
	
	Normally, 'Differencial Backup' of BE is....
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sun&nbsp;&nbsp;&nbsp; Mon&nbsp;&nbsp;&nbsp; Tue&nbsp;&nbsp;&nbsp; Wed&nbsp;&nbsp;&nbsp; Thu&nbsp;&nbsp;&nbsp; Fri&nbsp;&nbsp;&nbsp; Sat
	--------------------------------------------------------------------------------------
	Backup Exec&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Full&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -----------------------
'Differencial Backup' means the differencial from Sunday.
	
	But, I will set as follows,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sun&nbsp;&nbsp;&nbsp; Mon&nbsp;&nbsp;&nbsp; Tue&nbsp;&nbsp;&nbsp; Wed&nbsp;&nbsp;&nbsp; Thu&nbsp;&nbsp;&nbsp; Fri&nbsp;&nbsp;&nbsp; Sat
	--------------------------------------------------------------------------------------
	SQL Server Management Studio&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Full&nbsp;&nbsp; Full&nbsp;&nbsp; Full&nbsp;&nbsp; Full&nbsp;&nbsp; Full&nbsp;&nbsp; Full&nbsp;&nbsp; Full
	Backup Exec&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Full&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff&nbsp;&nbsp; Diff
'BE Diff on Monday' is the differencial from SQL Server Management Studio on Monday.
	'BE Diff on Tuesday' is the differencial from SQL Server Management Studio on Tuesday.
	
	But I want 'BE Diff on Monday' is the differencial from 'BE Full on Sunday'. ***2
	
	You said,
	&gt; BE will call the SQL Server API when it is backing up SQL Server databases.
	
	In other words, I cannot backup of ***2 .
	***2 is our best solution. But we need 'SQL Server Management Studio Full Backup every day'.
	I examine other way.

pkh · Answer

I don't know why you are backing up your SQL databases using both BE and the SQL Management Studio.&nbsp; If you need to do a full and an incremental backup each day, you can do so with just BE.&nbsp; You don't need to use SQL Management Studio.

takaratta · Answer

I also know it.
I need to arrange between end user and server administrator and so on....
If BE backup is different SQL Standard Backup Utility, I don't need to arrange.

Forum Discussion

What is internal processing of "Backup Exec Microsoft SQL Server Agent"?

5 Replies

Related Content

Backup Exec Domino DAOS backup without "Applications and Database Agent"

Backup Exec 2012 remote agent for windows stuck in "stopping" state

Backup Exec Client Agent 12.5 popup warning regarding ."Outlook: default mail client..."

Backup Exec Remote Agent stuck in "starting" state

"V-79-57344-862 - Backup Exec Agent for Microsoft Exchange wasn't used ..." but it was!

Recent Discussions

Backup Exec Job got canceled

BackupExec for Oracle 23ai?

Add Oracle DB in Backup Exec

Veritas Backup Exec version upgrade & migrate to another new Server

Veritas Backup Exec 23 - Slow Backup after Windows server 2019 upgrade