Welcome file

Veeam database size approaching limit

Problem:

My Veeam configuration was over 10,000mb approaching the MS-SQL express 10gb hard-limit.

Veeam: Configuration Database Issue The configuration database size
is approaching the limit. if this limit is exceeded, the backup server
will stop functioning.

Tentative Solution:

This worked for me, but may not be an official solution. I shrunk and rebuilt the indexes, no less than twice. I was able to shrink it half the size.

1. Backup the database manually, even if you have scheduled backups. “Hamburger” Menu>Configuration Backup>Backup Now.
2. Install and run SQL Server Management Server Studio.
3. Connect to the local Veeam database
4. Find and right click the “VeeamBackup” database, choose Tasks>Shrink>Database. Enable “Reorganize files before releasing…”>OK.
5. Copy and paste the rebuild-indexes SQL script from: https://www.mssqltips.com/sqlservertip/4470/script-to-manage-sql-server-rebuilds-and-reorganize-for-index-fragmentation/ to a new local script.
6. Edit the script’s SET parameters to suit your needs: SET @reportOnly = 0; & SET @fragmentationThreshold = 5; . Execute the script. This may grow your database too large, so…
7. Perform #4 again!
8. Perform #6 again!
9. Check the size of the database (This can be done by the shrink database menu or by viewing the database properties)

Documentation:

• Official KB: https://www.veeam.com/kb4024
• Forum Thread: https://forums.veeam.com/vmware-vsphere-f24/shrinking-the-veeambackup-database-t20276.html
• Community Thread: https://community.veeam.com/discussion-boards-66/procedure-to-shrink-the-vbr-database-2547

cannot paste clipbpard images into github

Problem

Cannot paste clipboard images into GitHub.com comments / editor using Firefox.

Solution

about:config > dom.event.clipboardevents.enabled = true .

---

How to set auto-power for iDrac 9

How to set auto-power for iDrac 9.

Problem:

iDrac 9 default Power Recovery is Last; However, APC UPS may shutdown a server externally, therefore power-up may not occur as expected.

Option 1 Solution:

BIOS (F2) > System Security > AC Power Recovery > On

Option 2 Solution:

ssh root@<IP-of-iDrac>
racadm get BIOS.SysSecurity.AcPwrRcvry
racadm set BIOS.SysSecurity.AcPwrRcvry On

Which will report:

RAC1017: Successfully modified the object value and the change is in 
     pending state.
     To apply modified value, create a configuration job and reboot 
     the system. To create the commit and reboot jobs, use "jobqueue" 
     command. For more information about the "jobqueue" command, see RACADM 
     help.

Therfore, to apply the new setting:

racadm jobqueue create BIOS.Setup.1-1

But it also requires a reboot. (Warning: Choose 2-stage graceshutdown + powerup, because any other seem to hard “reset”. )

racadm serveraction graceshutdown
racadm serveraction powerup

Expect a BIOS update and a reboot (slow).

Afterward, it may be verified via:

racadm get BIOS.SysSecurity.AcPwrRcvry

---

~ Good Luck! ~

---

SEO: Dell iDrac iDrac9 auto-power auto-start auto-power-on auto-power-up auto power powerup