I went through this link on stack exchange and also Brent Ozar's . I don't plan to create any differential backups for the AAG group. Can you please let me know if enabling this option should work. I will be adding a new database for an application, and I then plan to create and schedule Ola's scripts. Is it true that for new databases, only full backup happens and not the log backup? What can I do to resolve the issue? Please let know. Thanks!
- Why won't you use a differential backup? What's your reasoning?Randolph West– Randolph West2016-10-15 05:47:22 +00:00Commented Oct 15, 2016 at 5:47
- All the applications running on the SQL server are 3rd party vendor apps which are not revenue critical. Therefore only log backups and full backups are been taken as of nowbuddinggeek– buddinggeek2016-10-15 23:56:54 +00:00Commented Oct 15, 2016 at 23:56
Add a comment |
3 Answers
. I don't plan to create any differential backups for the AAG group. Can you please let me know if enabling this option should work.
Yes, it'll work.
Is it true that for new databases, only full backup happens and not the log backup?
I don't understand the question. If it's specific to Ola's script then I do not know, if it's a SQL Server question then you must take at least one full backup and one log backup before adding the database to the AG, so the answer would be no it isn't true.
What can I do to resolve the issue?
I currently do not see an issue. It's a valid backup strategy, now where or not it meets your recovery SLA in a disaster is another question.
You can check out "How should I configure DatabaseBackup to back up an Availability Group?" on https://ola.hallengren.com/frequently-asked-questions.html
- Thank you. So I followed what Brentozar mentioned with Olla hallengren and configured it on all the 3 modes. When I try to execute the job to test it, the job is failing. It says "unexpected parameter". The code I used in the job step isbuddinggeek– buddinggeek2016-10-17 00:40:26 +00:00Commented Oct 17, 2016 at 0:40
I am posting what I tried because, the comment section is not allowing me to post what I tried due to the "@" symbols
My code :
This is the code : sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q “EXECUTE [dbo].[DatabaseBackup] @Databases = ‘USER_DATABASES’, @Directory = N ’\SQL02\backups’, @BackupType = ‘FULL’, @Verify = ‘Y’, @CleanupTime = NULL, @Copyonly = ‘Y’, @LogToTable = ‘Y'” -b
- Could you script out the job and send that to me. ola.hallengren.com/contact.htmlOla Hallengren– Ola Hallengren2016-10-17 23:58:35 +00:00Commented Oct 17, 2016 at 23:58
- Thank you for reaching out. I have emailed you the job script!buddinggeek– buddinggeek2016-10-18 03:00:46 +00:00Commented Oct 18, 2016 at 3:00