SEPM 內嵌資料庫自動關閉的解法(內嵌資料庫瘦身法)

內嵌資料庫時常啟動後,會不定時關閉造成異常發生。試了很多方法最後用資料庫瘦身法,重新整頓內嵌資料庫可以解決資料庫不正常關閉的問題。

Solution:內嵌資料庫瘦身
The Dbunload tool is provided with Symantec Endpoint Protection 11.0.2 (Maintenance Release 2). To obtain Maintenance Release 2, read the document Accessing Maintenance Release 2 for Symantec Endpoint Protection 11.

Note: The problem that causes the embedded database to grow overly large is solved in Maintenance Release 2, but migrating to Maintenance Release 2 does not shrink the database automatically. To shrink the database, you must use the Dbunload tool.

To use the Dbunload tool

Stop the following services:
Symantec Endpoint Protection Manager
Symantec Embedded Database

Make a backup copy of the following file:

\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db

Start the service Symantec Embedded Database.
Click Start > Run, type CMD, click OK, and then type the following two lines at the prompt:

cd \Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32

dbunload -c “uid=dba;pwd=password_set_during_install" -ar

It takes about 10 minutes for the database file to shrink.

Note:
“password_set_during_install" is the password you supplied while installing Symantec Endpoint Protection Manager initially.

Restart the service Symantec Embedded Database.
Start the service Symantec Endpoint Protection Manager.

最後記得重開機..

之後會發現一切正常且資料庫有縮小

做這動作需要足夠的暫存空間供它使用

如果你本身的空間不足不夠它用…是不會成功的

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s