SQL Server Always On Series -
Database Backup and Maintenance Job to use Secondary Replica on a SQL Server Instance with Always On Availability group


[ Ссылка ]

Date 3/11/2023 1:58:28 PM
Log Job History (DatabaseBackup - USER_DATABASES - FULL)

Step ID 1
Server JBSAG1
Job Name DatabaseBackup - USER_DATABASES - FULL
Step Name DatabaseBackup - USER_DATABASES - FULL
Duration 00:00:01
Sql Severity 0
Sql Message ID 50000
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: JBSWIKI\jvivek2k1. Date and time: 2023-03-11 13:58:29 [SQLSTATE 01000] (Message 50000) Server: JBSAG1 [SQLSTATE 01000] (Message 50000) Version: 16.0.950.9 [SQLSTATE 01000] (Message 50000) Edition: Developer Edition (64-bit) [SQLSTATE 01000] (Message 50000) Platform: Windows [SQLSTATE 01000] (Message 50000) Procedure: [master].[dbo].[DatabaseBackup] [SQLSTATE 01000] (Message 50000) Parameters: @Databases = 'USER_DATABASES', @Directory = '\\JBSDC\Backup', @BackupType = 'FULL', @Verify = 'Y', @CleanupTime = 90, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'Y', @ChangeBackupType = 'N', @BackupSoftware = NULL, @CheckSum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @MinBackupSizeForMultipleFiles = NULL, @MaxFileSize = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @MirrorURL = NULL, @AvailabilityGroups = NULL, @Updateability = 'ALL', @AdaptiveCompression = NULL, @ModificationLevel = NULL, @LogSizeSinceLastLogBackup = NULL, @TimeSinceLastLogBackup = NULL, @DataDomainBoostHost = NULL, @DataDomainBoostUser = NULL, @DataDomainBoostDevicePath = NULL, @DataDomainBoostLockboxPath = NULL, @DirectoryStructure = '{ServerName}${InstanceName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @AvailabilityGroupDirectoryStructure = '{ClusterName}${AvailabilityGroupName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @FileName = '{ServerName}${InstanceName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @AvailabilityGroupFileName = '{ClusterName}${AvailabilityGroupName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @FileExtensionFull = NULL, @FileExtensionDiff = NULL, @FileExtensionLog = NULL, @Init = 'N', @Format = 'N', @ObjectLevelRecoveryMap = 'N', @ExcludeLogShippedFromLogBackup = 'Y', @DirectoryCheck = 'Y', @StringDelimiter = ',', @DatabaseOrder = N... Version: 2022-12-03 17:23:44 [SQLSTATE 01000] (Message 50000) Source: [ Ссылка ] [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000) Date and time: 2023-03-11 13:58:29 [SQLSTATE 01000] (Message 50000) Database: [JBSWiki] [SQLSTATE 01000] (Message 50000) State: ONLINE [SQLSTATE 01000] (Message 50000) Standby: No [SQLSTATE 01000] (Message 50000) Updateability: READ_WRITE [SQLSTATE 01000] (Message 50000) User access: MULTI_USER [SQLSTATE 01000] (Message 50000) Recovery model: FULL [SQLSTATE 01000] (Message 50000) Encrypted: No [SQLSTATE 01000] (Message 50000) Is accessible: Yes [SQLSTATE 01000] (Message 50000) Availability group: JBSAG [SQLSTATE 01000] (Message 50000) Availability group role: PRIMARY [SQLSTATE 01000] (Message 50000) Availability group backup preference: SECONDARY [SQLSTATE 01000] (Message 50000) Is preferred backup replica: No [SQLSTATE 01000] (Message 50000) Differential base LSN: 39000000156000001 [SQLSTATE 01000] (Message 50000) Last log backup LSN: 39000000264000001 [SQLSTATE 01000] (Message 50000) Allocated extent page count: N/A [SQLSTATE 01000] (Message 50000) Modified extent page count: N/A [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000) Date and time: 2023-03-11 13:58:29 [SQLSTATE 01000] (Message 50000) [SQLSTATE 01000] (Message 50000). The step succeeded.

Reference : [ Ссылка ]

свернуть