Forum Discussion
I'm sorry, *1 means as follows
> Our require of backup is...
> - Full Backup on Sunday
> - 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....
Sun Mon Tue Wed Thu Fri Sat
--------------------------------------------------------------------------------------
Backup Exec Full Diff Diff Diff Diff Diff Diff
| | | |
-------- | |
| | |
---------------- |
| |
-----------------------
'Differencial Backup' means the differencial from Sunday.
But, I will set as follows,
Sun Mon Tue Wed Thu Fri Sat
--------------------------------------------------------------------------------------
SQL Server Management Studio Full Full Full Full Full Full Full
Backup Exec Full Diff Diff Diff Diff Diff 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,
> 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.