1

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 Oct 15 '16 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 now – user2923332 Oct 15 '16 at 23:56
1

. 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.

1

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 is – user2923332 Oct 17 '16 at 0:40
0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.