Event ID: 3041 BACKUP failed to complete the command BACKUP LOG <database name>

Issue:
Error in Application log:
Event ID: 3041 BACKUP failed to complete the command BACKUP LOG <databasename>. Check the backup application log for detailed messages.
Source: MSSQL$SQLEXPRESS

Cause:
This issue happens when the db-backupoperator does not have backup permission on the problematic database. Follow the below procedure the solve the issue.

Solution:

1. Login to the server were the above mentioned problematic database is installed.
2. Open SQL Server management studio (SSMS) and login as domain Admin.
3. Then expand the Security folder > Expand Logins then select and right click NT AUTHORITY/SYSTEM account > click properties.
4. On the properties tab select User Mapping > click problematic database and put a check mark > then select 'db-backupoperator' and put a tick mark, click Ok. See the example screenshot below.
5. Close the SSMS  console.

Remove Rogue DHCP Authorized server from DHCP authorized list.

Some time we can see multiple DHCP server in the Manage Authorized Servers list of DHCP console, which is already removed from the domain. Before removing this make sure the IP address or server name is not present in AD or DNS. To remove this rogue DHCP server please follow the below steps.

1. Run the command to display the authorized server >netsh dhcp show server, then note the full FQDN server name and ip address and perform the following steps.
2. Type Net stop dhcpserver .
3. Netsh DHCP delete server Full server name IP address. Eg: C:\> netsh dhcp delete server Server-001.test.internal 192.168.0.10
4. Type Net start dhcpserver
5. Reboot the server and and check if it is displaying in the authorized list.

But if the old server still in the list then need to perform the below mentioned steps in Adsiedit:

1. Start Adsiedit.msc.
2. Right click ADSI Edit > click connect to > then select Configuration from select a well known naming context drop down list.
3. Expand the Configuration [Server Name] Container > then expand Services.
4. Select Net Services.
5. On the right hand side select record named CN=DHCPRoot.
6. Right Click the CN=DhcpRoot entry and then click Properties.
7. Highlight DhcpServers Attribute then click Edit button.
8. Highlight the entry with the rogue Domain name in the value box and click Remove. Click OK to close DHCPServers editors screen.
9. Once deleted the DHCPServers value will be displayed as not set.
10. Save the change by clicking OK and close Adsiedit.
11. Restart the DHCP server service.
12. Once you have restarted the DHCP Server service, run the following command: Netsh DHCP show server to confirm the old value is no longer displaying.

Adding sites to Internet Explorer 11 compatibility list via GPO

As per Microsoft Internet Explorer 11 no longer supports these Group Policy settings:
http://technet.microsoft.com/en-us/library/dn321453.aspx

• Turn on Internet Explorer 7 Standards Mode
• Turn off Compatibility View button
• Turn off Quick Tabs functionality
• Turn off the quick pick menu
• Use large icons for command buttons

Adding web site to Compatibility View List via GPO for IE 11.

1. In Windows 2008/2012 DC, open IE and add the web site to the Compatibility View Settings list.

2. Verify the setting in the registry key path HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\BrowserEmulation\ClearableListData\UserFilter

3. Open Group Policy Management Console by going to Administrative tools -> Group Policy management and select the User policy to edit.

4. Choose either Computer configuration or User Configuration.

5. Computer or User Configuration->Preference->Windows Setting->Registry.

6. Right click Registry and select New-> select Registry Wizard.

7. Select Local Machine and then check HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\BrowserEmulation\ClearableListData\UserFilter as below.


8. Click Finish.

9. Run gpupdate /force in DC.

10. Run gpupdate /force in a client machine or re-login.

11. You can check the registry key value in client machine and check in IE.

Extending Cluster Shared Volumes (CSV) VHD in iSCSI Target Server 2012.

1. Extend LUN using OEM-specific tools in case of SAN.

2.  In case of iSCSI Virtual Disk first you need to extend the partition were iSCSI VHD files reside (in my case D: drive) on the iSCSI Target server.

3. Then go to Server manager -> select File and storage service -> iSCSI

4. Right click the .vhd which need to be extended then select Extend iSCSI Virtual Disk and provide new size.

                            

5.  After extending LUN Find the CSV Owner which need to be extended by the following steps.

6.   Click Start, Administrative Tools, Failover Cluster Manager.

7.  Connect to the Cluster by clicking Manage Cluster from the MMC action pane

8.  Highlight the Cluster Shared Volumes node, and locate the server name under Current Owner.

9.  Then login to Cluster Owner server and go to Disk management.

10. From Disk management Action Menu -> Click ‘Rescan Disks’ and we can see the unallocated space there.

11. Right click the shared volume Disk and select Extend volume and provide the full unallocated space.

12. After that go to failover cluster and perform a refresh and now you can see the Cluster share volume is extended.