Sql-server – Schedule Full Backups

sql server 2014

Quick question. I'm using Ola's solution and with the full backup job for user databases, is there any issue scheduling these at the same time? I saw another thread on here that mentioned that it will just backup each DB one after the other but wanted to confirm?

Best Answer

If you run this command taken from ola's website it will backup all your user database one by one, if that is what you are asking. It will create a sub-folder under c:\backup\ for each database with its name. Each backup file will have server name, database name, date and timestamp.

EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@Verify = 'Y',
@Compress = 'Y',
@CheckSum = 'Y',
@CleanupTime = 24

If you need these same databases to backup in parallel you will need to create 4 jobs with database name passed to @Databases parameter and schedule at the same time.