commvault備份虛擬機失敗 There are too many existing backup snapshots on virtual machine

 環境:

commvault

異常狀況:

備份失敗

錯誤碼： [91:148] 描述： There are too many existing backup snapshots on virtual machine [xx]. Backup snapshots are being cleaned up, but manual intervention may be required to ensure that all snapshots are removed. This may indicate that the storage is unable to keep up with the I/O activity of the virtual machine during a backup. Source: backupserver, Process: vsbkp 

解決過程:

主要是因為備份虛擬機時，會先建立快照，但因為備份程式當掉，當成快照沒被清除。

之後要再備份就會出現此錯誤。

這時就連上esxi，到該虛擬機的快照管理中，把快照"全部刪除"，然後就可以正常備份了。

Environment:

Commvault

Issue:

Backup failed with the following error:

Error Code: [91:148]
Description:
There are too many existing backup snapshots on virtual machine [xx]. Backup snapshots are being cleaned up, but manual intervention may be required to ensure that all snapshots are removed. This may indicate that the storage is unable to keep up with the I/O activity of the virtual machine during a backup.
Source: backupserver
Process: vsbkp

Resolution:

This issue occurs because when backing up a virtual machine, the system first creates snapshots. However, if the backup process crashes or fails, the snapshots may not be removed properly.

When attempting the next backup, this error will appear.

To resolve the issue:

1. Log in to the ESXi host.

2. Open the Snapshot Manager for the affected virtual machine.

3. Select Delete All snapshots.

After removing all snapshots, the backup should run normally again.

SQL management tool連線時出現錯誤:此憑證鏈結是由不受信任的授權單位發出的

 

環境:

MS SQL2022

異常狀況:

SQL management tool連線時出現錯誤:此憑證鏈結是由不受信任的授權單位發出的

解決過程:

錯誤訊息「此憑證鏈結是由不受信任的授權單位發出的」是因為 SQL Server 2022 預設強制執行加密連線。

勾選下午的「信任伺服器憑證」選項，即可正常登入。

Environment:

MS SQL Server 2022

Issue:

When connecting using the SQL management tool, the following error appears:

“The certificate chain was issued by an authority that is not trusted.”

Resolution:

This error occurs because SQL Server 2022 enforces encrypted connections by default.

Enable the “Trust Server Certificate” option in the connection settings, and then you will be able to log in normally.

SQL 2022安裝時卡住不動

環境:

MS SQL2022

Kaspersky endpoint security

異常狀況:

MS SQL2022安裝到一半停住很久，cpu跟ram的使用資源都不會動。

解決過程:

將Kaspersky endpoint security防護暫停後，就會繼續安裝過程，完成剛裝

Environment:

MS SQL Server 2022
Kaspersky Endpoint Security

Issue:

During the installation of MS SQL Server 2022, the setup process gets stuck for a long time.
CPU and RAM usage remain unchanged and the installation does not continue.

Resolution:

After temporarily disabling Kaspersky Endpoint Security protection, the installation process resumes and completes successfully.

Synology 取消 "此裝置以後不需要驗證"

 環境:

Synology  NAS啟用 2FA的"此裝置以後不需要驗證"，需要取消

解決過程:

管理者登入後，到使用者設定中，在該帳號底下，選擇"登出所有裝置"，就會跳出說明，提醒這樣也會取消信任裝置。

之後同設備要登入時，就要輸入2FA的驗證碼。

Environment:

On a Synology NAS, 2FA is enabled and the option “Trust this device / Do not require verification on this device in the future” needs to be revoked.

Resolution / Steps:

1. Log in as an administrator.

2. Go to User settings.

3. Under the target user account, select “Sign out of all devices”.

4. A prompt will appear explaining that this action will also revoke trusted devices.

After this, when the same device logs in again, it will be required to enter the 2FA verification code.

Backup exec 的資料庫備份

  環境:

Backup exec 2014

異常狀況:

想要透過Backup exec 本身的工具beutility.exe，把Backup exec 自己的設定db檔匯出到其他存放。

但執行beutility.exe指令時，都會先跳出一個警告視窗，因為無法設定用batch自動執行。

解決過程:

Backup exec 的主程式裡就有可以設定db檔定期匯出到預設資料夾的功能了，不需要額外用beutility.exe來執行。

在"組態與設定"->"Backup Exec設定"，裡面有一個"資料庫維護"，就可以設定排程來做這件事。

Environment:

Backup Exec 2014

Issue:

Attempting to use Backup Exec’s built-in tool beutility.exe to export the Backup Exec configuration database to another storage location.
However, when running beutility.exe, a warning dialog always appears, making it impossible to automate the process using a batch script.

Resolution / Workaround:

Backup Exec already provides a built-in feature to periodically export the database to a default folder, so there is no need to use beutility.exe.

In Configuration and Settings → Backup Exec Settings, there is a Database Maintenance option where you can configure a scheduled task to perform this database export automatically.

python抓取元大rtd裡的欄位即時資料範例

 import xlwings as xw

import time

# 連接當前開啟的 Excel 檔案

wb = xw.Book('txf.xlsm')

sheet = wb.sheets['價格記錄']

while True:

    # 假設元大 RTD 資料在 A1 儲存格

    price = sheet.range('A2').value

    print(f"當前即時價格: {price}")

    # 根據需求設定取樣頻率 (例如每秒 1 秒)

    time.sleep(1)

Windows 資料夾透過FASTCOPY同步到NAS共用資料夾 權限並沒有同步

 環境:

Windows 資料夾透過FASTCOPY，同步到NAS共用資料夾

異常狀況:

資料夾開始建立進行同步時，發現權限並沒有同步過去

解決過程:

研究了很久，發現測試的資料夾正常，正式要同步的資料夾會有問題。

原來是資料夾第一次在同步時，還沒全部完成前去查看資料夾權限時，不會是最後的結果，所以要等同步完再檢查，就會發現資料夾的ACL權限有全部同步過去了。

Environment:

Windows folders synchronized to a NAS shared folder using FastCopy.

Issue:

When the folder creation and synchronization start, the folder permissions (ACLs) do not appear to be synchronized to the NAS.

Resolution / Findings:

After extensive investigation, it was found that test folders behaved normally, while the production folders showed this issue.

The root cause is that during the initial synchronization, if you check the folder permissions before the sync process has fully completed, the permissions shown are not the final result.
Once the synchronization finishes completely and you recheck the folder permissions, you will see that the ACL permissions have been fully and correctly synchronized.

Unifi Controller 與 AP 設定

 環境:

Unifi  軟體式Controller，安裝在windows主機。

搭配 U6 無線AP 。

設定過程:

1.先下載windows版的controller程式"UniFi Network Application 10.0.160 for Windows"

https://ui.com/download/releases/network-server 

2.安裝在windows主機上後，一開始會叫你登入unifi官網的帳號密碼，可以跳過，直接設定一組在這個controller上單獨登入的帳密就好。

3.在Setting功能中，去設定WIFI的SSID跟密碼。

4.AP直接接上網路，讓它自動透過DHCP抓到IP，要先跟controller同網段才行。

5.回到controller的畫面，在Unifi Device的頁籤裡，就會自動去找到網路環境中的AP，畫面上會顯示Adope的選項。

6.Adope之後，AP就可以加入這個controller的管控，之後AP就可以改成其他網段的IP。

筆電安裝win10/11 找不到ssd硬碟

環境:

ASUS or ACER筆電

異常狀況:

重灌win10 or win11系統時，在選擇要安裝在哪個磁區，不會顯示ssd硬碟的磁區。

解決過程:

1.下載irst這個驅動程式，asus網站上有提供。

https://www.asus.com/tw/supportonly/irst/helpdesk_download/

2.將該程式放入win10 or win11的安裝usb中。

3.安裝win10 or win11系統時，在選擇要安裝在哪個磁區的步驟，選擇載入驅動程式，然後選擇irst。

4.ssd磁碟就會正常顯示出來。

Environment:

ASUS or ACER laptops

Issue:

When reinstalling Windows 10 or Windows 11, the SSD drive does not appear during the disk selection step of the installation process.

Resolution / Troubleshooting Steps:

1. Download the IRST (Intel Rapid Storage Technology) driver (available on the ASUS website).

2. Copy the driver to the Windows 10 or Windows 11 installation USB drive.

3. During the Windows installation, at the step where you choose the disk to install the OS, select Load driver, then choose the IRST driver.

4. The SSD drive will then be displayed correctly.

點選右下角的日期時間 不會跳出月曆

   環境:

WIN 11點選右下角的日期時間，不會跳出月曆

解決過程:

1.windows鍵+ r鍵 ，輸入 regedit

2.找到HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\Windows\Explorer\

3.把DisableNotificationCenter設成 0

Environment:

On Windows 11, clicking the date and time in the bottom-right corner does not display the calendar.

Resolution :

1.Press Windows key + R, then type regedit.

2.Navigate to:

HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\Windows\Explorer\

3.Set DisableNotificationCenter to 0.