Video Screencast Help

SEPM DB SIZE

Created: 14 Feb 2013 | 13 comments

SEPM Version: 11.0.2000.1567

 

The DB size is over 8GB, how can I reduce it? I have only 30 clients.

Comments 13 CommentsJump to latest comment

Ashish-Sharma's picture

HI,

You can shrik your databse size

How to shrink the embedded database for the SEPM using the Dbunload tool

 

Article:TECH104278  |  Created: 2008-01-26  |  Updated: 2012-05-23  |  Article URL http://www.symantec.com/docs/TECH104278

 

Thanks In Advance

Ashish Sharma

 

 

Ambesh_444's picture

 

Hello,

Folow this below link...the issue is common...

http://www.symantec.com/business/support/index?page=content&id=TECH166658&key=54619

 

Symantec Endpoint Protection Manager 12.1 database using a high amount of Hard drive space

https://www-secure.symantec.com/connect/articles/symantec-endpoint-protection-manager-121-database-using-high-amount-hard-drive-space

Shrink the Symantec Endpoint Protection Manager 12.1 embedded database

https://www-secure.symantec.com/connect/downloads/shrink-symantec-endpoint-protection-manager-121-embedded-database

Symantec Endpoint Protection Manager server has low disk space and the embedded database log file size is large

http://www.symantec.com/docs/TECH166658

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

arazas's picture

I dont have password for this:

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

SebastianZ's picture

This will be the DB password set during installation - it may be the same as the admin password you use to login the console if it hasn't been changed since installation.

You are using 11 MR2 - this version is 3 years old upgrade would be really recommended, currently newest SEP 11 Release is RU7 MP3

http://www.symantec.com/business/support/index?pag...

Mithun Sanghavi's picture

Hello,

I would suggest you to follow the steps provided in the Article:

Disk Space Management procedures for the Symantec Endpoint Protection Manager

http://www.symantec.com/docs/TECH96214

Secondly, You are running a very old version of SEPM 11.0.2000 which was released on Apr 2008

Currently Latest version is SEPM 11. 0.7300. 

What are the Symantec Endpoint Protection (SEP) versions released officially?

https://www-secure.symantec.com/connect/articles/what-are-symantec-endpoint-protection-sep-versions-released-officially

I would highly recommend you to migrate the Latest version to SEPM 11. 0.7300

Check this Article:

Latest Symantec Endpoint Protection Releases - SEP 12.1 RU2 and SEP 11.0 RU7 MP3

https://www-secure.symantec.com/connect/articles/latest-symantec-endpoint-protection-releases-symantec-endpoint-protection-121-ru2

If you are planning to upgrade or migrate to Symantec Endpoint Protection 12.1.2, please take a look at the latest how-to article created by our very own SEP content council team.
 

Hope that helps!!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

Rafeeq's picture

The version what you are using is very old more than 3 years old i guess. this version had lot of bugs.

install the latest 12.1 version.

since you have only 20 clients.

a fresh install would help you a lot.

http://www.symantec.com/business/support/index?pag...

 

 

Symantec Endpoint Protection 12.1: Installing the Manager for the first time and deploying clients

 
Chetan Savade's picture

Hi,

Will it be possible to upgrade to the lateset SEP version i.e. SEP 12.1 RU2?

Upgrade is free for all the existing SEP 11 customers.

SEP 11.x to SEP 12.1 Upgrade process graphical overview

https://www-secure.symantec.com/connect/articles/s...

It's also important to know what are the new features in SEP 12.1

Few differences between SEP 11.x and SEP 12.1 EE

https://www-secure.symantec.com/connect/articles/f...

If not planning to make the upgrade, then refer the following articles

Configuring the number of content revisions kept by the SEP client 11.x (cachentriesex)

http://www.symantec.com/business/support/index?pag...

Maintaining the database

http://www.symantec.com/docs/HOWTO55337

Changing the log settings to reduce the size of the database.

http://www.symantec.com/docs/TECH105238

I hope it's informative.

 

Chetan Savade
Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

arazas's picture

Many thanks for you all.

Because our subscriptiion is expired and it was not renewable so we have already placed the order to a local vendor for SYMC PROTECTION SUITE ENTERPRISE EDITION 4.0 Upgrade.

Hopefully we will recieved the license within the start of next week and then I will plan for upgrade.

1) Now should I wait for DB SHRINK or I can go ahead?

2) SEPM password was changed several times and I dont know the password because it was installed in 2008 by some other Administrator.

Chetan Savade's picture

Hi,

DB shrink tool is designed for SEP 12.1 product.

In your case I would suggest wait till you receive new product subsciption if you have sufficient disk space available.

Instead of an upgrade I would suggest to go with fresh install because in future you may required DBA password.

Promote this idea: https://www-secure.symantec.com/connect/ideas/sepm...

However give a try to recover the DB password with the help of following article.

https://www-secure.symantec.com/connect/articles/h...

If plannig to do a fresh install then can refer this artilce

SEPM 12.1 Fresh install with Embedded database - graphical overview

https://www-secure.symantec.com/connect/articles/s...

 

 

Chetan Savade
Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

Mithun Sanghavi's picture

Hello,

Upon checking your Thread:

https://www-secure.symantec.com/connect/forums/symc-disk-full

It seems your issue is resolved.

I understand your situation. In your case, here are the Answers - 

1) Now should I wait for DB SHRINK or I can go ahead?

Since you have only 30 clients and running a 8 GB Database which seems obvious that the Database may have some corruption.

I would suggest you to go ahead with Migration.

2) SEPM password was changed several times and I dont know the password because it was installed in 2008 by some other Administrator.

Since SEPM password has been changed a number of time, you could still change the password as you do not know.

This could be done via resetpass.bat.

To reset the password, follow the below steps:

1. Open a command prompt window.

2. Navigate to the Tools subfolder in the Symantec Endpoint Protection Manager directory on the drive and location where you installed the manager.

Note: The default installation path is C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Tools

3. From the command line run the batch file named "resetpass.bat" This will reset the password to a default user name and password of admin/admin.

4. Following login, user will be prompted to change the password. The password may be the same as the previous password.

Hope that helps!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

arazas's picture

Dear Mithun Sanghavi.

I would be getting SYMC PROTECTION SUITE ENTERPRISE EDITION 4.0 license in next week. As you said, I will proceed for Migration. (I cant shrink DB in current version right?)

How can I migrate to Version 11 to SYMC PROTECTION SUITE ENTERPRISE EDITION 4.0? Any help documents, checklist or things to consider for safe migration?

Thank you

 

Ambesh_444's picture

Hello,

Please check with these..

http://www.viosoftware.com/Protection+Suite+Ent+Basic/Protection+Suite+Enterprise+Edition+4.0+250-499+Users+Upgrade+(Basic+Maintenance).html?utm_source=LinkShare&utm_medium=affiliate&utm_campaign=4GMSOZU0-BI1EE&siteID=bfebyuN173M-by5Ip0CAqYkwi0x74ec6Zw

 

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."