When using Veeam Backup & Replication 9.5 to backup SQL Server 2012 databases the transaction log was failing to be truncated for one database. The database was using the full recovery model and the user account specified in Veeam’s Application Aware Processing had the required permissions and was successfully truncating the log of other databases on the same SQL instance. The warning is displayed in Veeam as below.
Veeam logs additional information in the VeeamGuestHelper log in C:\ProgramData\Veeam\Backup\VeeamGuestHelper_DATE.log.
To resolve the error I added the following registry keys in the two locations below. In my case the full registry path didn’t exist under Wow6432Node so I had to create it manually.
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\VeeaM\Veeam Backup and Replication\
HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and Replication\
If you’re encountering this error it my be due to a large number of SQL Server virtual log files (VLFs). See these blog posts for more information on the issue and how to resolve it.
A Busy/Accidental DBA’s Guide to Managing VLFs
Transaction Log VLFs – too many or too few?
I recently encountered an issue where a server wouldn’t install any Windows Updates, whether directly from Microsoft, or if downloaded from the Windows Update Catalog. The error message received was “Windows cannot install required files error 0x80070570” and this is how I resolved the error.
From an administrative command prompt I ran the System File Checker using sfc /scannow. This stopped with an error at 36%. The log for sfc is in the %windir%\Logs\CBS folder.
Next, I used the Deployment Image Servicing and Management (DISM) tool to perform a health scan of the Windows system files. Again, I ran this from an administrative command prompt, Dism /Online /Cleanup-Image /ScanHealth, but it showed no errors.
Despite the fact no corruption was detected, I ran the following command to fix corruption, Dism /Online /Cleanup-Image /RestoreHealth. In my case, rather than using Windows Update to retrieve fresh files, I used the /Source switch to point to a copy of the SXS folder from a Windows installation ISO.
Having fixed the corruption Windows Updates now installed.
When deploying the Windows 10 April 2018 Update (1803) via SCCM the update fails to install with error 0x87D0070C.
In Event Viewer you see the error “Installation Failure: Windows failed to install the following update with error 0x800704C7: Feature update to Windows 10 (business editions), version 1803, en-gb.”
The error is caused by the default maximum run time setting in SCCM of 60 mins, which in this case is insufficient for the update to install and it times out. To increase the timeout value, find the update within the Software Updates section of SCCM, right-click on the update and select properties.
Increase the value to something like 240 mins and click OK.
When installing the Windows 10 April 2018 Update (1803) the installation fails with error 0x80070241. When installing via SCCM you see the error “The software change returned error code 0x80070241(-2147024319).”
In Event Viewer you see the error “Installation Failure: Windows failed to install the following update with error 0x80070241: Feature update to Windows 10 (business editions), version 1803, en-gb.”
To resolve the issue uninstall the Windows Assessment and Deployment Kit – Windows 10 (ADK).
If you try to RDP to a machine, but can’t because you receive the error below, you can use PSExec to remotely disable the requirement for NLA.
“The remote computer that you are trying to connect to requires Network Level Authentication (NLA), but your Windows domain controller cannot be contacted to perform NLA. If you are an administrator on the remote computer, you can disable NLA by using the options on the Remote tab of the System Properties dialog box.”
Download PSExec from TechNet. Run the code below updating the following values.
\\VMNAME – The name of the machine on which you want to disable NLA
VMNAME\ADMIN_ACCOUNT – The username of a local administrator on the machine on which you want to disable NLA, e.g. pc1\admin
psexec \\VMNAME -u VMNAME\ADMIN_ACCOUNT -p PASSWORD reg add “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp” /f /v SecurityLayer /t REG_DWORD /d 0
Power Map, which is part of Microsoft’s Power BI, requires an Office 365 version of Excel. When attempting to install Excel via Office 365 on a server I ran into the error:
Error Code 30125-4 when installing Office 365 Something went wrong. Sorry, we ran into a problem
Although the proxy was configured in Control Panel -> Internet Options, I had to enable the proxy via an elevated command prompt. Type: netsh winhttp set proxy %Address of proxy server% bypass-list=(local)
This will configure the proxy server and setup proxy bypass for local addresses.
This is a quick post to describe the process of creating a dedicated account for joining machines to an Active Directory (AD) domain. This is useful for things like System Center Configuration Manger task sequences and System Center Virtual Machine Manager templates.
First create a standard Windows user account. Next, right-click on the Computers Organisation Unit (OU) within your AD domain. From the menu choose Delegate Control…
On the next screen (Users or Groups) choose Add and select the user account you just created. Click Next. Choose “Create a custom task to delegate” on the next screen.
Next, choose to only delegate control to computer objects and tick Create and Delete selected objects in this folder. Click Next.
On the next screen choose to show general permissions and from the list select:
- Reset password
- Read and write account restrictions
- Validated write to DNS host name
- Validated write to service principal name
Click Next and finish to complete the wizard. Repeat this process for any other OUs where you’ll be joining computers to the domain.