November 8, 2018 at 5:58 am
I just ran Ola's script in one of the server which is running 2008R2 SQL Server and it failed due to this error below. However, this script is running just fine on other server (2016 SQL Server)
Unable to start execution of step 1 (reason: Variable SQLLOGDIR not found). The step failed.
Has anyone run into the same issue?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
November 8, 2018 at 7:38 am
I ran the same script on another server running on the same version of SQL Server and it is running just fine.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
November 8, 2018 at 8:10 am
Administering Databases - Thursday, November 8, 2018 7:37 AMI ran the same script on another server running on the same version of SQL Server and it is running just fine.
I've seen that error posted recently and from what I've read it looks like it's an issue with SQL Server earlier versions not being detected correctly in the scripts.
Read through this post for more information:
Variable SQLLOGDIR not found error while running Ola index job
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply