Ola Hallengren's Maintenance question

Question

Ola Hallengren's Maintenance question

sqlfriend

SSC Guru

Points: 52769
More actions
June 25, 2018 at 11:52 am

#413965

I have a SQL server 2016 server that uses Ola Hallengren's Maintenance solution,
Yesterday I got an alert SQL Server Alert System: '016 - Miscelaneous User Error that says:
DESCRIPTION: ExtendDisk Backup: failure on backup device'G:\Backup\Myservername01\MyDBName\FULL\SNOCECMSQP01_MYDB_FULL_20180624_000141.bak'.Operating system error 112(There is not enough space on the disk.).

But I cannot find the error in my CommandLog table.
I thought it will record a message in the table. Did I miss something?
Thanks,

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

sqlfriends - Monday, June 25, 2018 11:52 AM
I have a SQL server 2016 server that uses Ola Hallengren's Maintenance solution,
Yesterday I got an alert SQL Server Alert System: '016 - Miscelaneous User Error that says:
DESCRIPTION: ExtendDisk Backup: failure on backup device'G:\Backup\Myservername01\MyDBName\FULL\SNOCECMSQP01_MYDB_FULL_20180624_000141.bak'.Operating system error 112(There is not enough space on the disk.).

But I cannot find the error in my CommandLog table.
I thought it will record a message in the table. Did I miss something?
Thanks,

You need to enable the logging using the @LogToTable parameter. The default for that is 'N', you need to set it to 'Y'

Sue

sqlfriend SSC Guru Points: 52769 More actions · Answer 2

Thanks, I checked in the job we do set up to log into the table.

And later found is someone worked on Sunday did a manual backup, he probably did not use the log into table parameter.

Perry Whittle SSC Guru Points: 233865 More actions · Answer 3

sqlfriends - Monday, June 25, 2018 11:52 AM
I have a SQL server 2016 server that uses Ola Hallengren's Maintenance solution,
Yesterday I got an alert SQL Server Alert System: '016 - Miscelaneous User Error that says:
DESCRIPTION: ExtendDisk Backup: failure on backup device'G:\Backup\Myservername01\MyDBName\FULL\SNOCECMSQP01_MYDB_FULL_20180624_000141.bak'.Operating system error 112(There is not enough space on the disk.).

But I cannot find the error in my CommandLog table.
I thought it will record a message in the table. Did I miss something?
Thanks,

OS Error 112

the volume is out of space when the backup run

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Jeff Moden SSC Guru Points: 1003865 More actions · Answer 4

sqlfriends - Monday, June 25, 2018 2:21 PM
Thanks, I checked in the job we do set up to log into the table.
And later found is someone worked on Sunday did a manual backup, he probably did not use the log into table parameter.

Someone needs to have a serious talk with that person and, perhaps, the whole group. No one, not even another DBA, should be doing ad hoc backups without doing things like checking for diskspace prior to backups and they certainly shouldn't be doing something manual when a system like Ola's is in play. And, If it wasn't a DBA that did the nasty, then you have much bigger problems with your security.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sqlfriend SSC Guru Points: 52769 More actions · Answer 5

She is working to setup a content manage system with a vendor off hour. the vendor probably did a full backup before he is doing the upgrade, that is sending alert to me. She also happen to be the security manager..and she likes to work independently 🙂

Jeff Moden SSC Guru Points: 1003865 More actions · Answer 6

sqlfriends - Friday, July 6, 2018 9:54 AM
She is working to setup a content manage system with a vendor off hour. the vendor probably did a full backup before he is doing the upgrade, that is sending alert to me. She also happen to be the security manager..and she likes to work independently 🙂

So what? She's not exempt and someone needs to call her out on it. It would seem she likes to work independently because she doesn't want to have to explain her poor habits. 😉 A security manager should know better.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)