Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when LOG_SIZE_SINCE_LAST_LOG_BACKUP_* is specified #337

Closed
Rob-S opened this issue Jan 22, 2020 · 1 comment
Closed

Error when LOG_SIZE_SINCE_LAST_LOG_BACKUP_* is specified #337

Rob-S opened this issue Jan 22, 2020 · 1 comment

Comments

@Rob-S
Copy link

Rob-S commented Jan 22, 2020

Description of the issue

Error: The value for the parameter @DatabaseOrder is not supported. The column sys.dm_db_log_stats.log_since_last_log_backup_mb is not available in this version of SQL Server.

SQL Server version and edition
Execute SELECT @@VERSION
Microsoft SQL Server 2017 (RTM-CU17) (KB4515579) - 14.0.3238.1 (X64) Sep 13 2019 15:49:57 Copyright (C) 2017 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: )

Version of the script
Check the header of the stored procedure
[DatabaseBackup] Version: 2020-01-14 21:48:14

What command are you executing?
EXECUTE [dbo].[DatabaseBackup]
@Directory = N'.../directory/path/...',
@BackupType = N'LOG',
@Cleanuptime = 200,
@DatabaseOrder = N'LOG_SIZE_SINCE_LAST_LOG_BACKUP_DESC';

What output are you getting?
The value for the parameter @DatabaseOrder is not supported. The column sys.dm_db_log_stats.log_since_last_log_backup_mb is not available in this version of SQL Server.

Rob-S added a commit to Rob-S/sql-server-maintenance-solution that referenced this issue Jan 22, 2020
Rob-S added a commit to Rob-S/sql-server-maintenance-solution that referenced this issue Jan 22, 2020
@olahallengren
Copy link
Owner

This issue has been fixed. Thank you for reporting it, and finding the issue in the code.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants