commvault 備份時會當機

  環境:

commvault

x3650m3

win2012

異常狀況:

已經運作多年的備份主機，突然開始在備份時會當機，備份比較大的資料才會當機，只是少量的就不會，不執行備份放一整個晚上也都沒問題。

當機後通常會進到藍底白字畫面，搜尋相關錯誤資訊，但未有任何進度就會直接重開機。

沒有memory dump檔，事件檢視器也沒有任何可參考的資訊，只會有意外當機的事項。

IMM 的log裡也沒有任何的異常。

raid程式裡，硬碟與raid卡都健康。

用內建的記憶體測試，正常。

解決過程:

關閉防毒->無效

調低備份的Maximum number of parallel data transfer operations->無效

關機拔電後重開->無效

拔掉六條記憶體擦一擦，只插回基本的兩條->無效

在找不到任何方法下，先把記憶體全部插回，再試試，居然就正常了....

Environment:

Commvault
IBM x3650 M3
Windows Server 2012

Issue:

A backup server that had been running normally for many years suddenly began crashing during backup operations.
The crash only occurred when backing up large amounts of data. Backups with small amounts of data completed normally, and the server could remain powered on overnight without issues if no backup jobs were running.

After the crash, the system usually entered a blue screen. When attempting to view the error details, the system rebooted before any useful information could be collected.

Additional observations:

• No memory dump files were generated.

• Event Viewer only recorded an unexpected shutdown with no useful details.

• IMM logs showed no abnormalities.

• RAID management reported that the disks and RAID controller were healthy.

• The built-in memory diagnostic test passed without errors.

Troubleshooting Process:

• Disabled antivirus → No effect

• Reduced Maximum number of parallel data transfer operations in Commvault → No effect

• Powered off the server and unplugged power before restarting → No effect

• Removed six memory modules, cleaned them, and left only two installed → No effect

With no other solutions available, all memory modules were reinstalled again.
Unexpectedly, after reinstalling all the RAM, the system returned to normal operation and the backup jobs completed successfully.

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.