Handling split backups with Ola Hallengren script

The below mentioned query will used for split backups which is extracted from Ola Hallengren scripts.

@NumberOfFiles parameter will create mentioned files.

EXECUTE [dbo].[DatabaseBackup]
@Databases = 'ALL_DATABASES',
@Directory = 'N:\SQLBackups\' ,
@BackupType = 'FULL',
@Verify = 'Y',  
@CleanupTime = 168,
@CheckSum = 'Y',
@LogToTable = 'Y',
@compress='Y',
@NumberOfFiles=3

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server