I recently implemented Ola Hallengren Maintenance solution on all of my production servers(SQL server 2005,2008,2008R2 and 2012). It works great.
My problem is how to implement Ola Hallengren backup plan on the server for some databases nightly full backups and for other weekly full backup only. To be specific I have 20 databases on the server. It is required 15 databases have nightly full backup plan. The remaining five databases should have weekly database full backup.
I scheduled the backup job for 15 databases nightly full backup. It is working great. But I don’t know how to take care the remaining five databases weekly full backup. (SQL Server 2008R2) On native maintenance plan I used to create two plans 1. Nightly full backup for the 15 databases and 2. Weekly full backups for the remaining five databases I don’t know how to do that on ola. Do I need to install ola Backup solution again for the five databases? Or is there another way to do it?
I copy and past the script from ola User database job substitute my databases on the place of user databases and create backup job as follows
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d MASTER -Q "EXECUTE [dbo].[DatabaseBackup] @Databases = 'DB1,DB2,DB3,DB3,DB4,Db5', @Directory = N'C:\Backup2', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 72, @CheckSum = 'Y', @LogToTable = 'Y'" -b
I run a test backup . It worked but I am not sure that is the right way doing it or not? could you please somebody tell me whether it is ok or not. Thank you your help in advance.
@KASQLDBA I have attached the error screen shot