Endpoint Protection

 View Only

Shrink the Symantec Endpoint Protection Manager 12.1 embedded database 

Mar 26, 2012 09:51 PM

We have created a tool based on customer demand to shrink the Symantec Endpoint Protection Manager 12.1 embedded database.  Here are the steps to use this tool:

1. Backup your database.

Before running this tool, please backup the DB manually by stopping the Symantec Endpoint Protection Manager service and copying the sem5.db and sem5.log from "..\Symantec\Symantec Endpoint Protection Manager\db\"  to another folder. You can copy them back and start the SEPM service and embedded database service to restore the previous SEPM status.

2. Copy this tool into the "Tools" folder of the SEP Manager.

Copy the file ShrinkEmbeddedDB.bat and ShrinkEmbeddedDB.jar to folder "..\Symantec\Symantec Endpoint Protection Manager\Tools\".

3. Double click file ShrinkEmbeddedDB.bat or run it from a command window.

4. Follow the prompt of the tool to delete the sem5.db.bak and sem5.log.bak after shrinking the database successfully.

** Updated to work with SEPM 12.1.2 (RU2) **

Legal: Symantec shall not be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with your use of or reliance of this tool.

Statistics
0 Favorited
18 Views
1 Files
0 Shares
3 Downloads
Attachment(s)
zip file
ShrinkEmbeddedDB.zip   12 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Comments

Mar 24, 2015 04:09 AM

Hi, I have tried to run this tool for SEPM 12.1.4 and have got the next error:

C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools>Shrin
kEmbeddedDB.bat
java.io.IOException: Couldn't get lock for C:\Program Files (x86)\Symantec\Syman
tec Endpoint Protection Manager\Tools\..\tomcat\logs\scm-server-%g.log
        at java.util.logging.FileHandler.openFiles(FileHandler.java:389)
        at java.util.logging.FileHandler.<init>(FileHandler.java:323)
        at com.sygate.scm.server.util.ServerLogger.<clinit>(ServerLogger.java:12
5)
        at com.sygate.scm.tools.db.ShrinkEmbededDB.initLogger(ShrinkEmbededDB.ja
va:75)
        at com.sygate.scm.tools.db.ShrinkEmbededDB.main(ShrinkEmbededDB.java:93)

Exception in thread "main" com.sygate.scm.server.util.ScmServerError: java.io.IO
Exception: Couldn't get lock for C:\Program Files (x86)\Symantec\Symantec Endpoi
nt Protection Manager\Tools\..\tomcat\logs\scm-server-%g.log
        at com.sygate.scm.server.util.ServerLogger.<clinit>(ServerLogger.java:17
0)
        at com.sygate.scm.tools.db.ShrinkEmbededDB.initLogger(ShrinkEmbededDB.ja
va:75)
        at com.sygate.scm.tools.db.ShrinkEmbededDB.main(ShrinkEmbededDB.java:93)

Caused by: java.io.IOException: Couldn't get lock for C:\Program Files (x86)\Sym
antec\Symantec Endpoint Protection Manager\Tools\..\tomcat\logs\scm-server-%g.lo
g
        at java.util.logging.FileHandler.openFiles(FileHandler.java:389)
        at java.util.logging.FileHandler.<init>(FileHandler.java:323)
        at com.sygate.scm.server.util.ServerLogger.<clinit>(ServerLogger.java:12
5)
        ... 2 more

Mar 20, 2015 08:35 AM

Just shrank a version 12.1.5 sem5.db and it worked as expected.

Feb 17, 2015 12:46 PM

Disable the Symantec Embedded Database service in services.msc.

Two ways for next step - "Stop database service"

Open Task Manager > Services tab > Identify and stop Symantec Embedded Database service

or

Open a command prompt, enter: ' tasklist | find /I "dbsrv" ' and then ' taskkill PID# '  (PID from tasklist output).

Watch out for Symantec Management Client restarting the DB service. If so, you stop it by running smc.exe -stop command from Symantec Endpoint Protection install directory.

 

Jan 15, 2015 08:25 AM

Does this work for the Small Business Edition?

Nov 17, 2014 08:57 AM

Just shrank a version 12.1.4a sem5.db and it worked as expected.

Came across a second sem5.db in the \Symantec Endpoint Protection Manager\ASA\win32\ folder. Wondering what this other one is good for?

Nov 10, 2014 03:01 PM

I have never seen this before.  Have you tried stopping both the SEPM and the SEPM Web Server services first?  I wonder if you have some other application on SEPM that is preventing you from stopping the SEPM database service.

Nov 08, 2014 01:40 PM

Running SEP SBE 12.1.4.

I do not see any method of manually stopping the Symantec Embedded Database.  It is started automatically, and even "run as administrator" on Services does not provide a Start/Stop option.

Only the SEPM and SEPM Web Server have the option to be stopped. 

Now what?

Oct 22, 2014 04:13 PM

The Symantec Endpoint Protection Manager has three services.  You will need to stop all three before you can copy the db files as they are locked by the Endpoint Protection Manager database service.  Once you have finished all steps you can restart the three services again.

Oct 21, 2014 07:29 PM

The original instructions are not clear...it mentions to stop the SEP Manager Service only then copy the files for backup. By doing this is does not allow you to copy the db files?

Could you please verify if there are other services that should be stopped?

When do we start up the services again...at which stage?

Thank you.

Oct 21, 2014 07:05 PM

The original instructions are not clear...it mentions to stop the SEP Manager Service only then copy the files for backup. By doing this is does not allow you to copy the db files?

Could you please verify if there are other services that should be stopped?

When do we start up the services again...at which stage?

Thank you.

Oct 06, 2014 09:51 AM

Maybe I missed it mentioned in the above thread and if so, sorry....

After stopping the SEPM and Embedded database services to copy the SEM5.* files for backup...do these services get re-enabled BEFORE kicking off the tool, or do the services stay stopped?

 

 

Aug 06, 2014 05:27 AM

RU4a seems to have a problem with it.

If I run the batch file from the tools folder and have stopped the tasks, it still gets me an "Failed to unload DB"

What can be the reason for this? There are no further infos coming up, to diagnose the problem. I am not being asked a password - is it necessary?

May 19, 2014 06:15 PM

This will work with RU4.  Verify you have enough disk space and that you have stopped all 3 of the SEPM services.  This will usually take 2x to 3x of the embedded database size.  So if for example your embedded database is 2 GBs then I recommend having at least 4 GBs free.

May 12, 2014 04:52 PM

so i attempted to run this on RU4. All went well until the end when it starts adding the Dat files to the DB.

 

I recieved an error stating that it could not find the *.MT table & bombed out...'

 

anyone know what i can do do shirink this thing?

 

I was able to restore my backup & all is working well. but our DB is a bit bigger than it should be

May 12, 2014 01:24 PM

does this work with RU4?

 

we have just updated & want to shirnk the DB

Apr 14, 2014 04:48 PM

This is the only Tools folder I can find --> c:\Program Files (x86)\Symantec\Symantec Protection Center\Tools

Apr 14, 2014 04:44 PM

yep, try that location as well.

Apr 14, 2014 04:40 PM

Should it be under c:\Program Files (x86)\Symantec?

Apr 14, 2014 04:36 PM

Are you sure you're on the SEPM then? It has to be there if this is the SEPM.

Could it have been moved to another drive?

Apr 14, 2014 04:32 PM

I do not see a Tools folder under Symantec Endpoint Protection Manager on the C drive.

 

Apr 14, 2014 04:01 PM

No, needs to be on the SEPM itself

"..\Symantec\Symantec Endpoint Protection Manager\Tools\"

Apr 14, 2014 03:56 PM

It is located here --> c:\Program Files (x86)\Symantec\Symantec Protection Center\Tools

Is that the correct spot?

Apr 14, 2014 02:11 PM

Did you follow Step 2?

2. Copy this tool into the "Tools" folder of the SEP Manager.

Copy the file ShrinkEmbeddedDB.bat and ShrinkEmbeddedDB.jar to folder "..\Symantec\Symantec Endpoint Protection Manager\Tools\".

Run from the Tools folder

Apr 14, 2014 02:08 PM

I cannot get this to work for 12.1

All I get is a black command screen that appears for less than a half second.

Does it still work for 12.1?

Mar 31, 2014 03:21 PM

Nice Article..

Mar 13, 2014 04:20 AM

Hi

I ran batch file. but I can't see sem5.db.bak and sem5.log.bak file at 'D:/Symantec Enpoint Protection/db'

I think I failed to shrink Database. How can I do next?
 

SEPM12.1

Windows Server 2008 R2 (Vmware)

 

 

Jan 29, 2014 02:46 PM

Haven't seen an update to this since 12.1.2, and was running into the same trouble nathans77 posted about above.

In the error trace, it gives you the command line it's trying to do -- basically the same dbunload.exe instructions from http://www.symantec.com/business/support/index?page=content&id=TECH104278

I used the steps outlined below, and was able to shrink a 4.5 GB database down to 3.7 GB.  Not a lot of space reclaimed, but I'll take it.

DISCLAIMER:  while the steps worked fine for me, I make no guarantees that it will work for you.  YMMV, backup first, etc. etc.

1. Backup your SEPM database using the Database Back Up and Restore tool.  I also made a backup copy of the sem5.db file just in case...

2. Stop the services for:

  • Symantec Embedded Database
  • Symantec Endpoint Protection Manager
  • Symantec Endpoint Protection Manager Webserver

3. Open a command prompt as administrator, and run the following command.  Where I use <SEPMPATH> below, replace with the Path to your SEPM install (ex "C:\Program Files\Symantec\Symantec Endpoint Protection Manager")

<SEPMPATH>\ASA\win32\dbunload.exe -ar -c "UID=dba;pwd=<YOURPASSWORD>;dbf=<SEPMPATH>\db\sem5.db" "<SEPMPATH>\dbdump" -r "<SEPMPATH>\dbdump\reload.sql" -v -q -y -o "<SEPMPATH>\dbdump\unload.log"

4. Wait for the command to complete.  Grab a coffee or something.

5. Check the results of unload.log and make sure there weren't any errors.

6. Start the services you stopped in step 2, and resume using SEPM.

Dec 16, 2013 02:00 AM

hi all,

 

does this thread still ok?

Dec 12, 2013 01:39 AM

Also, just an additional question to all:

 

If I have multiple SEPM, replicated, do I need to apply it to all or just 1 SEPM server only then rereplicate them? Do I need to cut the replication before applying the tool? Any suggestions on how to clean the embedded database?

 

Thanks!

 

 

Dec 12, 2013 01:32 AM

any answers on the above queries? I want to try the tool but i want to make sure of the things i need to do before acting on the said issue. Been reading all the comments above but it doesn't seems to answer the questions being delivered by the users.

Dec 05, 2013 04:42 PM

SEPM 12.1.3

When running the bat file I get this...

Info: Before shrinking DB, Please backup DB first!! This tool will stop the SEPM service.

Here's the command info...

C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools>Shrin
kEmbeddedDB.bat
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: ================== Server Environment ===================
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: os.name = Windows Server 2008 R2
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: os.version = 6.1
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: os.arch = x64
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: java.version = 1.7.0_21
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: java.vendor = Oracle Corporation
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: java.vm.name = Java HotSpot(TM) Client VM
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: java.vm.version = 23.21-b01
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: java.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection
 Manager\jre
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: catalina.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protec
tion Manager\Tools\..\tomcat
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: java.user = null
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: user.language = en
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: user.country = US
Dec 05, 2013 3:39:42 PM com.sygate.scm.server.util.ServerLogger writeHeader
SEVERE: scm.server.version = 12.1.3001.165
Has valid SAV license
Info>> No SNAC license file in C:\Program Files (x86)\Symantec\Symantec Endpoint
 Protection Manager\Tools\..\tomcat\etc\license
Dec 05, 2013 3:39:43 PM com.sygate.scm.tools.db.ShrinkEmbededDB initLogger
INFO: logger initialized ...
Dec 05, 2013 3:39:43 PM com.sygate.scm.tools.db.ShrinkEmbededDB shrinkDB
INFO: shrinkDB: Start to shrink DB.
Dec 05, 2013 3:39:43 PM com.sygate.scm.tools.db.ShrinkEmbededDB detectBackupFile

INFO: detectBackupFile: Detect bak DB file ...
Dec 05, 2013 3:39:51 PM com.sygate.scm.tools.db.ShrinkEmbededDB stopTomcat
INFO: stopTomcat: Stopping Tomcat services...
Executing command - stop semsrv
The Symantec Endpoint Protection Manager service is not started.

More help is available by typing NET HELPMSG 3521.

Waiting for service termination: semsrv
Checking whether the service is stopped: semsrv
Retrieve status for service semsrv
The status for semsrv' service is 1
Service is stopped.
Dec 05, 2013 3:39:51 PM com.sygate.scm.tools.db.ShrinkEmbededDB shrinkDB
INFO: shrinkDB: The OS is Windows 2008....
Dec 05, 2013 3:39:51 PM com.sygate.scm.tools.db.ShrinkEmbededDB shrinkDB
INFO: shrinkDB: Stopping DB service....
Dec 05, 2013 3:39:51 PM com.sygate.scm.tools.db.ShrinkEmbededDB stopDBServices
INFO: stopServices: Stopping DB services...
Executing command - stop SQLANYs_sem5
The Symantec Embedded Database service is not started.

More help is available by typing NET HELPMSG 3521.

Waiting for service termination: SQLANYs_sem5
Checking whether the service is stopped: SQLANYs_sem5
Retrieve status for service SQLANYs_sem5
The status for SQLANYs_sem5' service is 1
Service is stopped.
Dec 05, 2013 3:39:51 PM com.sygate.scm.tools.db.ShrinkEmbededDB shrinkDB
INFO: shrinkDB: The DB vendor is:Embedded
Dec 05, 2013 3:39:51 PM com.sygate.scm.tools.db.ShrinkEmbededDB unloadDB
INFO: unloadDB: [Thu Dec 05 15:39:51 CST 2013] Start to unload the DB....
Dec 05, 2013 3:39:51 PM com.sygate.scm.tools.db.ShrinkEmbededDB unloadDB
INFO: unloadDB: The command line is:"C:\Program Files (x86)\Symantec\Symantec En
dpoint Protection Manager\ASA\win32\dbunload.exe" -c "UID=dba;pwd=**********;dbf
=C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\db\sem5.db
" "C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\dbdump"
-r "C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\dbdump\
reload.sql" -v  -q  -y  -o "C:\Program Files (x86)\Symantec\Symantec Endpoint Pr
otection Manager\dbdump\unload.log"
Error occurred.Dec 05, 2013 3:39:51 PM com.sygate.scm.tools.db.ShrinkEmbededDB m
ain
INFO: Error occurred. The exception is: Executable name has embedded quote, spli
t the arguments
java.lang.IllegalArgumentException: Executable name has embedded quote, split th
e arguments
        at java.lang.ProcessImpl.isQuoted(ProcessImpl.java:160)
        at java.lang.ProcessImpl.getExecutablePath(ProcessImpl.java:201)
        at java.lang.ProcessImpl.<init>(ProcessImpl.java:242)
        at java.lang.ProcessImpl.start(ProcessImpl.java:133)
        at java.lang.ProcessBuilder.start(ProcessBuilder.java:1023)
        at java.lang.Runtime.exec(Runtime.java:615)
        at java.lang.Runtime.exec(Runtime.java:483)
        at com.sygate.scm.tools.db.ShrinkEmbededDB.unloadDB(ShrinkEmbededDB.java
:358)
        at com.sygate.scm.tools.db.ShrinkEmbededDB.shrinkDB(ShrinkEmbededDB.java
:160)
        at com.sygate.scm.tools.db.ShrinkEmbededDB.main(ShrinkEmbededDB.java:100
)

I've already backed up the db, but what else is it needing?

Thanks

Nov 15, 2013 10:33 AM

Hi: I followed the instructions for running the tool, and the command window is still open with the last command:

Waiting for service running: SQLANYs_sem5
Checking whether the service is running SQLANYs_sem5
'SQLANYs_sem5' service is running...
        STATE              : 4  RUNNING
The service SQLANYs_sem5 has already been started.
Executing command - start semsrv
The Symantec Endpoint Protection Manager service is starting.
The Symantec Endpoint Protection Manager service was started successfully.
 
Nov 15, 2013 9:11:29 AM com.sygate.scm.tools.db.ShrinkEmbededDB cleanupDump
INFO: cleanupDump: Cleanup dump files....
Nov 15, 2013 9:11:29 AM com.sygate.scm.tools.db.ShrinkEmbededDB shrinkDB
INFO: shrinkDB: End to shrink DB.
 
It has been sitting like this for the past hour...has it completed or is it still running? In the dB directory, I see:
 
sem5.db.bak -- 3.1 GB
sem5.log.bak -- 2.5 GB
 
sem5.db -- 2.5 GB
sem5.log -- 44 MB
 
I see the timestamps on the log and db files changing every couple of minutes, but they are not changing in size at this point.
 

Oct 17, 2013 01:46 PM

I'm having an issue with this tool running in 12.1.3 as well except I do not get an error. The tool stops the services then nothing happens. I just let the server sit there for 30 minutes without doing anything to see if I was going to get an error and nothing happened. Was this tool ever updated for 12.1.3? My drive is running low on storage and I would like to shrink this DB if possible. I really do not want to add more storage because, well, the DB will just keep growing.

Sep 18, 2013 03:56 PM

Will this be updated to work with RU3?

It very likely is an error in Java, something changed that requires " or ', maybe?

Thanks

Sep 12, 2013 01:44 PM

Same error here.

SEPM 12.1.3

Aug 22, 2013 01:02 PM

Is this something that can be run silently to allow it to be run as a scheduled task?  This would make it easier to automate the maintenance of the sem5.db.

 

Other than that, it is a very nice utility that I know I will keep handy.

Jul 31, 2013 11:51 AM

Thanks guys. Looks like I will have to manage this a little more closely....

 

Jul 31, 2013 10:21 AM

I can second the error that M. Goud describes above. If Elisha would be so kind as to update this great utility so that is supports SEP 12.1.3, we would all be very greatful. Ok...at very least, I would. :-)

Thanks for the support!!

-Mike

Jul 30, 2013 10:05 PM

Hi Frank,

Do you have multiple sites of SEPM? Please set the replicate option to replicate log only. Try to shrink the DB more often.

One more note: Sometimes the transaction logs grow too big and you can not truncate it on the SEPM. You have to stop the Manager service and also the embedded database, delete the log file mannually and start these 2 services again.

The log file located in: "Your SEPM Folder\db\sem5.log"

Jul 30, 2013 09:47 PM

Normally it gets that large because there are a lot of SEP client packages and AV definitions files in the database.  The database file size should show the 'peek' database size.  Once the database file consumes space it does not give up the space without manually shrinking it.  This is normal most databases.  Since yours is 100GBs it shows that most likly at one point in time you had 100GBs of data in the database (the peek usage).

SEP does not automatically shrink the database.  Shrinking the database requires SEPM to be turned off and the database to be unloaded.  However SEPM does automatically manage the database by truncating the transaction logs and rebuilding the index files.

Jul 30, 2013 03:00 PM

Hi. I see that Symantec has a "tool" to "shrink" the SEM5 database but I have a broader question. Why does it get so large in the first place? Is there an automatic routine that will keep this database manageable? The process ate up my hard drive in about 2 months (100G). Did I set this Endpoint Mgr. app up incorrectly?

Thanks.

 

Jul 08, 2013 08:18 AM

This tool doesn't work anymore after upgrading to 12.1 RU3.

When run, it stops the services and then terminates with the following error:

"Error occurred.Jul 01, 2013 10:35:17 AM com.sygate.scm.tools.db.ShrinkEmbededDBmain
INFO: Error occurred. The exception is: Executable name has embedded quote, split the arguments"
 
The tool seems to have problems with the newer JRE which comes with the new release.
 
As a workaround I restored the older version to the %CD%\JRE folder and adjusted the batch file.
 
Could you publish a new version?

May 17, 2013 09:10 PM

The tool is looking for a table called "mt".  However this table is not needed and the tool will to run fine once you click "Continue" on this error.  You can safely ignore the "Table 'mt' not found" error message.

May 07, 2013 06:34 PM

I too am having this issue although every time I would hit exit.  I ended opening a case to try and solve it.  The case number was 04182597, but is now closed and it was unresolved.  Would you like me to also send you a copy of my database?  I also have a screenshoot of the commandline as well.  Thanks for your help.

Mar 28, 2013 11:10 PM

Hello pkecun, would you be able to send me a copy of your database that has this issue?  Our development team would like to look at it to see what the issue is.

Mar 18, 2013 11:07 AM

I've also seen this this morning.

Mar 16, 2013 05:24 AM

I've experienced the same thing but not at every site so not sure if it's DBUnload or a problem with the DB.

If you edit the reload.sql file after DBUnload has finished dumping, you can see that the section to create the mt table is commented out..

 

-------------------------------------------------
--   Create tables
-------------------------------------------------
 
----CREATE TABLE "DBA"."mt" (
----    "id"                             integer NULL
----   ,"name"                           char(20) NULL
----)
----go
----

but further down it tries to load into the table..

 

LOAD TABLE "DBA"."mt" ("id","name")
    FROM 'C:/Program Files (x86)/Symantec/Symantec Endpoint Protection Manager/dbdump/703.dat'
    FORMAT 'TEXT' QUOTES ON
    ORDER OFF ESCAPES ON
    CHECK CONSTRAINTS OFF COMPUTES OFF
    STRIP OFF DELIMITED BY ','
    ENCODING 'UTF-8'
go
 

Despite having that problem, I've kept a backup and left the shrunk DB in place. If I experience any strangeness, will let you know.

Mar 14, 2013 01:36 PM

It looks like the transaction log has not been truncated.  I recommend logging on to the management server console, going to the Admin --> Servers tab and clicking on the database node from the Servers tree.  From there you can run the "Truncate Transaction Log Now" task.  This should shrink that file.

Once you have done that I recommend that you click "Edit the Database Properties" and enable the two Database Maintenance Tasks and chose a schedule for them run on a regular basis.  The recommended setting is to truncate the transaction log daily and rebuild the indexes once a week.

Mar 14, 2013 09:07 AM

Dear All,
please suggest what information contain sem5.log file.
in my condition its size is 159 GB. kindly suggest what i should do.
----subhash

Mar 07, 2013 04:53 PM

I've just tried running this tool on our server, and got an error when Reloading DB.  The progress bar is at 80%, and a window came up titled dbisqlc, with this text:

Error in file: "C:\program files (x86)\Symantec\Symantec Endpoint Protection Manager\dbdump\reload.sql" at line 9100 

Table 'mt' not found

The window has Continue, Stop, and Exit buttons.  I hit continue, but it doesn't seem to be doing anything at this point, the progress bar hasn't moved since the error came up.

 

Edit: Okay, a few minutes after posting, the progress bar moved on and I got a notice that the shrink completed successfully.  Based on that error message, should I restore the old db files at this point to avoid db issues related to this error, or is the shrunken db ok to use?

Feb 27, 2013 10:17 PM

Thanks Elisha for your update. It works properly on our SEPM 12.1.2 (RU2)

Feb 06, 2013 02:40 PM

Ok.  I reposted it.  This time without the password.

Feb 06, 2013 10:56 AM

I downloaded the zip file to fun the program, but when I try to extract it is asking for a password to extract the files?

Feb 04, 2013 05:12 PM

I updated the tool to work with SEPM 12.1.2 (RU2).

Jan 04, 2013 02:25 PM

That's great to hear. Thanks for the update, keep up the great work!

Jan 03, 2013 07:59 PM

We are working on an update for this tool that works on SEP 12.1 RU2.

Dec 31, 2012 11:42 AM

actually you have got the answer in your previous thread i.e. about different version.
with RU 2 you have to rely on the DB maintenance.

Dec 31, 2012 11:26 AM

Because once you've done numerous SEPM upgrades and removed the many (no longer needed) older installation packages, the DB file itself doesn't automatically shrink (unless there's another automated process somewhere, didn't see anything in the SEPM console)

It isn't a big deal most of the time, the re-index and truncate are working as expected, I was just trying to avoid database bloat as I have several installations I've inheritied that are installed on smaller partitions and for one reason or another (mostly politic) moving the installation to a different partition isn't feasible so I've got to keep the size down.

Dec 31, 2012 11:17 AM

this is fixed in latest version, why do you want to run on SEP 12.1 RU 2?

Dec 31, 2012 10:47 AM

I've had success using this tool in the past but doesn't seem to work with SEP 12.1 RU2. Any chance of this being updated?

Dec 31, 2012 3:34:04 PM com.sygate.scm.tools.db.ShrinkEmbededDB initLogger INFO: logger initialized ... Dec 31, 2012 3:34:04 PM com.sygate.scm.tools.db.ShrinkEmbededDB shrinkDB INFO: shrinkDB: Start to shrink DB. Dec 31, 2012 3:34:04 PM com.sygate.scm.tools.db.ShrinkEmbededDB getDBProperties INFO: getDBProperties: The JDBC driver class is: sybase.jdbc4.sqlanywhere.IDriver Dec 31, 2012 3:34:04 PM com.sygate.scm.tools.db.ShrinkEmbededDB getDBProperties INFO: getDBProperties: The JDBC url is: jdbc:sqlanywhere:CommLinks=tcpip(dobroadcast=none;host=localhost;port=2638;verify=no);ServerName=localhost Dec 31, 2012 3:34:04 PM com.sygate.scm.tools.db.ShrinkEmbededDB checkDBType INFO: checkDBType: The DB is not embeded DB Dec 31, 2012 3:34:04 PM com.sygate.scm.tools.db.ShrinkEmbededDB shrinkDB INFO: shrinkDB: The current DB is not Embeded DB! Cannot shrink this DB!</PLAINTEXT> <div>I&#39;m guessing this is because the embedded database server has switched from &quot;Adaptive Server Anywhere 11.0.1.2472&quot; in SEPM 12.1.1101.401. RU1 MP1 to &quot;Embedded (SQL Anywhere) 12.0.1.3551&quot; in SEPM 12.1.2015.2015.</div> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_60" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Dec 27, 2012 10:15 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_60_pnlProfileImage_60" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_60_imgProfile_60_lnkDisplay_60" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_60_imgProfile_60_imgNoImage_60" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>I tried shrinking the dataqbase, receive the following error:</p> <p>&quot;C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools&gt;Shr<br /> kEmbeddedDB.bat<br /> java.io.IOException: Couldn&#39;t get lock for C:\Program Files (x86)\Symantec\Sym<br /> tec Endpoint Protection Manager\Tools\..\tomcat\logs\scm-server-%g.log<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.logging.FileHandler.openFiles(FileHandler.java:372)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.logging.FileHandler.&lt;init&gt;(FileHandler.java:306)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sygate.scm.server.util.ServerLogger.&lt;clinit&gt;(ServerLogger.java:<br /> 9)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sygate.scm.tools.db.ShrinkEmbededDB.initLogger(ShrinkEmbededDB.<br /> va:75)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sygate.scm.tools.db.ShrinkEmbededDB.main(ShrinkEmbededDB.java:9<br /> <br /> Exception in thread &quot;main&quot; com.sygate.scm.server.util.ScmServerError: java.io.<br /> Exception: Couldn&#39;t get lock for C:\Program Files (x86)\Symantec\Symantec Endp<br /> nt Protection Manager\Tools\..\tomcat\logs\scm-server-%g.log<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sygate.scm.server.util.ServerLogger.&lt;clinit&gt;(ServerLogger.java:<br /> 4)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sygate.scm.tools.db.ShrinkEmbededDB.initLogger(ShrinkEmbededDB.<br /> va:75)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sygate.scm.tools.db.ShrinkEmbededDB.main(ShrinkEmbededDB.java:9<br /> <br /> Caused by: java.io.IOException: Couldn&#39;t get lock for C:\Program Files (x86)\S<br /> antec\Symantec Endpoint Protection Manager\Tools\..\tomcat\logs\scm-server-%g.<br /> g<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.logging.FileHandler.openFiles(FileHandler.java:372)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.util.logging.FileHandler.&lt;init&gt;(FileHandler.java:306)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sygate.scm.server.util.ServerLogger.&lt;clinit&gt;(ServerLogger.java:<br /> 9)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ... 2 more<br /> <br /> &quot;</p> <p>I tried copying the sem5.db and .log for to a different directory (not sure what copying the file accomplishes in the first place, but hey).. made no difference.</p> <p>&nbsp;</p> <p>Any help is appreciated</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_61" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Nov 21, 2012 06:40 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_61_pnlProfileImage_61" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_61_imgProfile_61_lnkDisplay_61" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_61_imgProfile_61_imgNoImage_61" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Hello Kaz,</p> <p>The SEPM database should not be using that much disk space.&nbsp; It could be quite fragmented&nbsp; If the customer is using SEP 12.1 then you could follow these steps (note some customer data will get lost here):</p> <p>1. Export each of the policies out of SEPM.</p> <p>2. Uninstall SEPM and delete the database file.&nbsp; Make sure to to keep the Recovery File, this is needed to restore client communicating.</p> <p>3. Install SEPM using the Recovery File.</p> <p>4. Import the policies back into SEPM</p> <p>If you are still having issue feel free to contact me offline by sending me a message via SymConnect.&nbsp; I can help you with this.</p> <p>Thanks,</p> <p>Elisha</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_62" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Nov 17, 2012 11:42 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_62_pnlProfileImage_62" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_62_imgProfile_62_lnkDisplay_62" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_62_imgProfile_62_imgNoImage_62" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>I&#39;ve followed the instructions above, but when I run the <strong>ShrinkEmbeddedDB </strong>tool it halts at the &quot;detectBackupFile&quot; step, with the following message:</p> <p><em>Detect bak DB file ...</em></p> <p>(It&#39;s been stopped at this step for several hours now.)</p> <p><em><strong>The SEP software has used 264 GB of the 280 GB available on the hard disk, which (needless to say) is absolutely ridiculous.</strong></em> As a result, the mail server has stopped working and the customer is not receiving work-related emails - which is obviously having a serious impact on their business.</p> <p>Is there a way to get this tool to run properly, or should we just uninstall the product and get the customer to use a less-bloated software security product? (such as Avira)</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_63" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Nov 09, 2012 01:57 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_63_pnlProfileImage_63" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_63_imgProfile_63_lnkDisplay_63" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_63_imgProfile_63_imgNoImage_63" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>I&#39;m getting the same error.&nbsp; I stopped the SEPM service and the embedded database service.&nbsp; Created a subfolder (C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\Backup DB) and then copied sem5.db and sem5.log to that folder.&nbsp; When I run the tool it stops with the error &quot;Failed to unload DB&quot;.&nbsp; SEPM service and the embedded database service are stopped after the error.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_64" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Oct 03, 2012 01:08 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_64_pnlProfileImage_64" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_64_imgProfile_64_lnkDisplay_64" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_64_imgProfile_64_imgNoImage_64" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Is there a way to rebuild the sem5.db from the unloaded data stored during the shrinkembeddeddb.bat process? I have a folder full of what seem to be juicy files and information waiting to be loaded back into a database...</p> <p>I&#39;m just not readily aware of a process list to do so.</p> <p>No, during the backup process, the sem5.db.bak was lost, so I do not have that.</p> <p>When I attempt to recover from the symantec recovery application it errors on the connection.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_65" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Aug 31, 2012 12:07 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_65_pnlProfileImage_65" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_65_imgProfile_65_lnkDisplay_65" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_65_imgProfile_65_imgNoImage_65" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Hello Victor,</p> <p>This tool will free up unused space from the database file.&nbsp; Since your database file did not have any unused space it could not make the database file any smaller.</p> <p>In your case it increased the size by 12MBs which is one tenth of one percent (0.1%).&nbsp; This is normal, as the tool will rebuild the database file from scratch and when this happens the database will reserve room between each table in the database to allow additional data to be inserted later, this way the tables won&#39;t get as fragmented when they grow.</p> <p>Thanks,</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_66" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Aug 30, 2012 10:35 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_66_pnlProfileImage_66" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_66_imgProfile_66_lnkDisplay_66" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_66_imgProfile_66_imgNoImage_66" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>I have negative experience....</p> <p>For shrink db with size 12 999 MB toll was demanded 38 GB free disk space.</p> <p>After completion tools work db size growth to 13 011 MB.</p> <p>Regards.</p> <p>Victor</p> <p>&nbsp;</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_67" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Aug 29, 2012 06:31 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_67_pnlProfileImage_67" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_67_imgProfile_67_lnkDisplay_67" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_67_imgProfile_67_imgNoImage_67" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Unfortunately there is no way to change the temp folder for this tool.&nbsp; You need to make sure that you have enough disk space before running this tool.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_68" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Aug 16, 2012 01:06 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_68_pnlProfileImage_68" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_68_imgProfile_68_lnkDisplay_68" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_68_imgProfile_68_imgNoImage_68" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>This question needs to be answered!</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_69" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Aug 16, 2012 12:58 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_69_pnlProfileImage_69" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_69_imgProfile_69_lnkDisplay_69" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_69_imgProfile_69_imgNoImage_69" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>We also have this issue..</p> <p>I have now run the shrink.dbf ansd its errored out onec with &quot;lack of space&quot;!!!!!</p> <p>We have now deleted the two backups stored localy and re-run..</p> <p>It is now stuck at 10% progress and the disk space is running out again!!!!!</p> <p>Symantec, you need to provide more information on what this shrink actually does before advising users to rune it!!!</p> <p>I am now stuck here waiting for it to fail again when the disk space has been depleted, again..</p> <p>Any assistance ASAP would be greatly appreceated..</p> <p>E.g How much space do we require to run this fix in the 1st instance is a good 1st question..</p> <p>Regards,</p> <p>DaveW...</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_70" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Aug 05, 2012 03:08 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_70_pnlProfileImage_70" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_70_imgProfile_70_lnkDisplay_70" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_70_imgProfile_70_imgNoImage_70" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Dear Ashish,</p> <p>Thanks for your quick response, request you to kindly go ahead to the new thread&nbsp;</p> <p>&nbsp;</p> <p>Best Regards</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_71" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Aug 05, 2012 01:17 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_71_pnlProfileImage_71" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_71_imgProfile_71_lnkDisplay_71" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_71_imgProfile_71_imgNoImage_71" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>hi,</p> <p>Sure we will help you with that, But do you mind creating a new thread for this.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_72" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Aug 05, 2012 12:44 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_72_pnlProfileImage_72" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_72_imgProfile_72_lnkDisplay_72" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_72_imgProfile_72_imgNoImage_72" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>&nbsp;</p> <p>Dear All ,</p> <p>Our SEPM 12.1 was working perfectly , from yesterday started the problem, &nbsp;&nbsp;Symantec &nbsp;Embedded&nbsp; Database services not starting &nbsp;( no any error message) . I have downloaded &nbsp;the tool and run with the instruction&nbsp; , but I &nbsp;am getting error &ldquo; fail to unload DB&rdquo;</p> <p>Anyone can help us &nbsp;from&nbsp; this&nbsp; situation , it should be a great appreciate&nbsp;</p> <p>Regards&nbsp;</p> <p>Tom</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_73" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Jul 24, 2012 02:58 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_73_pnlProfileImage_73" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_73_imgProfile_73_lnkDisplay_73" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_73_imgProfile_73_imgNoImage_73" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>No.&nbsp; This is not intended to reduce the memory usage of the Embedded database.&nbsp; The memory usage of the Embedded database is configured based on how many users you selected when you installed the product.&nbsp; Note: if using the SBE version it will be set to 256MBs.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_74" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Jul 24, 2012 06:27 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_74_pnlProfileImage_74" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_74_imgProfile_74_lnkDisplay_74" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_74_imgProfile_74_imgNoImage_74" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Thank you for your answer.</p> <p>One last question, will the memory usage of the DBSRV9 reduce as well?&nbsp;</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_75" biobubblekey="54e8df3f-bb4a-42e5-9bb2-c2a767049194" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=54e8df3f-bb4a-42e5-9bb2-c2a767049194">Chetan Savade</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Jul 24, 2012 02:46 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_75_pnlProfileImage_75" biobubblekey="54e8df3f-bb4a-42e5-9bb2-c2a767049194"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_75_imgProfile_75_lnkDisplay_75" biobubblekey="54e8df3f-bb4a-42e5-9bb2-c2a767049194" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=54e8df3f-bb4a-42e5-9bb2-c2a767049194"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_75_imgProfile_75_imgNoImage_75" title="Chetan Savade" height="50" width="50" biobubblekey="54e8df3f-bb4a-42e5-9bb2-c2a767049194" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Thanks Elisha for providing this tool. It&#39;s great help to the support team.</p> <p>&nbsp;</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_76" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Jul 23, 2012 02:04 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_76_pnlProfileImage_76" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_76_imgProfile_76_lnkDisplay_76" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_76_imgProfile_76_imgNoImage_76" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>It will work on SEP 12.1 Small Business Edition (SBE).&nbsp; It will not work on SEP 12.0 SBE.</p> <p>It can reduce the size of the database file in cases where the database file has gotten bloated.&nbsp; However it will not reduce the amount of data that is in the database itself.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_77" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Jul 22, 2012 02:07 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_77_pnlProfileImage_77" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_77_imgProfile_77_lnkDisplay_77" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_77_imgProfile_77_imgNoImage_77" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Will it work in Symantec endpoint protection small business edition 12 (where SPC is the management console)?</p> <p>Does it decrease the size of the database?</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_78" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Jun 19, 2012 03:40 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_78_pnlProfileImage_78" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_78_imgProfile_78_lnkDisplay_78" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_78_imgProfile_78_imgNoImage_78" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>i did.</p> <p>And copied the files to a different folder.. Not sure why copying the&nbsp;<span style="color: rgb(51, 51, 51); font-family: helvetica, arial, clean, sans-serif; line-height: 17px; ">sem5.db and sem5.log files makes any difference.. the tool doesn&#39;t ask which files to load.</span></p> <p>Unless you mean move the files.</p> <p>&nbsp;</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_79" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Jun 19, 2012 03:29 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_79_pnlProfileImage_79" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_79_imgProfile_79_lnkDisplay_79" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_79_imgProfile_79_imgNoImage_79" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Try stopping the SEP Manager and copying the sem5.db and sem5.log files to a separate folder first before running the tool.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_80" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Jun 19, 2012 01:06 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_80_pnlProfileImage_80" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_80_imgProfile_80_lnkDisplay_80" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_80_imgProfile_80_imgNoImage_80" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>I can&#39;t get this tool to work.</p> <p>&nbsp;</p> <p>I did as the article suggested, made backup of log and db, but when i run the tool i get &quot;failed to unload DB&quot; error.</p> <p>&nbsp;</p> <p>Shows the unloading DB gets to 55% and then dies.</p> <p>&nbsp;</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_81" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Apr 27, 2012 01:43 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_81_pnlProfileImage_81" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_81_imgProfile_81_lnkDisplay_81" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_81_imgProfile_81_imgNoImage_81" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>OS: Win2008R2 SP1<br /> Manager: 12.1.1000.157 (RU1)<br /> &nbsp;</p> <p>Manager was stopped and database service also.<br /> Without stopping DB service i could not copy log file to separate folder.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_82" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Apr 26, 2012 10:26 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_82_pnlProfileImage_82" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_82_imgProfile_82_lnkDisplay_82" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_82_imgProfile_82_imgNoImage_82" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>What version of the Symantec Endpoint Protection Manager are you using and what operating system do you have the SEP Manager installed on?</p> <p>Try stopping the SEP Manager and copying the sem5.db and sem5.log files to a separate folder first before running the tool.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_83" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Apr 26, 2012 07:54 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_83_pnlProfileImage_83" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_83_imgProfile_83_lnkDisplay_83" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_83_imgProfile_83_imgNoImage_83" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Shrinking stopped in the end with the message:</p> <p><em>error at line 1 cannot open transaction log file -- sem5.log</em></p> <p>Any info what could be the problem?</p> <p>&nbsp;</p> <p>&nbsp;</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_84" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Mar 31, 2012 08:24 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_84_pnlProfileImage_84" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_84_imgProfile_84_lnkDisplay_84" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_84_imgProfile_84_imgNoImage_84" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>this is awesome.</p> <p>thank you</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_85" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Mar 30, 2012 04:33 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_85_pnlProfileImage_85" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_85_imgProfile_85_lnkDisplay_85" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_85_imgProfile_85_imgNoImage_85" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Thank you for the tool. Any way to specify another temp folder for the temporary files created by shrink? We have the HD absolutelly full by the DB, and the only way to have free space is using external disk.</p> <p>Thank you</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_86" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Mar 29, 2012 12:40 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_86_pnlProfileImage_86" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_86_imgProfile_86_lnkDisplay_86" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_86_imgProfile_86_imgNoImage_86" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>No.&nbsp; Shrinking the database will not create performance issues.&nbsp; In fact in many cases it will make the database run faster.&nbsp; What happens is that over time data is added to the database and then removed from the database causing the database file to bloat.&nbsp; This bloat can cause performance issues.&nbsp; This tool will rebuild the database file, reducing the bloat and causing the data to be contiguous.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_87" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=909a8e41-f1e7-45af-914a-628128e3819f">Migration User</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Mar 29, 2012 09:58 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_87_pnlProfileImage_87" biobubblekey="909a8e41-f1e7-45af-914a-628128e3819f"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_87_imgProfile_87_lnkDisplay_87" class="aspNetDisabled"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_87_imgProfile_87_imgNoImage_87" height="50" width="50" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Awesome Tool for SEP 12.1</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_88" biobubblekey="98f3915a-e020-4aca-9f82-320c1cf1c3d3" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=98f3915a-e020-4aca-9f82-320c1cf1c3d3">Srikanth_Subra</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Mar 28, 2012 11:13 PM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_88_pnlProfileImage_88" biobubblekey="98f3915a-e020-4aca-9f82-320c1cf1c3d3"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_88_imgProfile_88_lnkDisplay_88" biobubblekey="98f3915a-e020-4aca-9f82-320c1cf1c3d3" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=98f3915a-e020-4aca-9f82-320c1cf1c3d3"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_88_imgProfile_88_imgNoImage_88" title="Srikanth_Subra" height="50" width="50" biobubblekey="98f3915a-e020-4aca-9f82-320c1cf1c3d3" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Ok..Thanks for the reply.</p> </div> </div> </div> </div> <div class="comments-block"> <div class="row"> <div class="col-md-12"> <p> <div class="ByLine"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_UserName_89" biobubblekey="98f3915a-e020-4aca-9f82-320c1cf1c3d3" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=98f3915a-e020-4aca-9f82-320c1cf1c3d3">Srikanth_Subra</a> </div> <div class="pull-right"> <div class="timeAgoFormat text-muted"> Mar 28, 2012 05:13 AM </div> </div> </p> </div> </div> <div class="row"> <div class="col-md-1 col-sm-1"> <div class='CommentUserProfile'> <div class="form-group"> <div class="col-md-12"> <div id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_89_pnlProfileImage_89" biobubblekey="98f3915a-e020-4aca-9f82-320c1cf1c3d3"> <a id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_89_imgProfile_89_lnkDisplay_89" biobubblekey="98f3915a-e020-4aca-9f82-320c1cf1c3d3" href="https://community.broadcom.com/symantecenterprise/network/members/profile?UserKey=98f3915a-e020-4aca-9f82-320c1cf1c3d3"><img id="MainCopy_ctl44_ItemCommentList_CommentsList_OwnerProfileInfo_89_imgProfile_89_imgNoImage_89" title="Srikanth_Subra" height="50" width="50" biobubblekey="98f3915a-e020-4aca-9f82-320c1cf1c3d3" src="https://d2x5ku95bkycr3.cloudfront.net/App_Themes/Common/images/profile/0_200.png" alt="" /></a> </div> </div> </div> </div> </div> <div class="col-md-11 col-sm-11"> <div class="panel panel-default panel-body"> <p>Thanks for sharing the tool, but having one doubt that shrinking of db will create any performance issues?</p> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div><div class="ContentUserControl HLLibraryViewControl"> <div class="row"> <div class="col-md-12"> <div id="MainCopy_ctl46_ItemRelatedResourcesList_UpdatePanel1"> <div class=""> <h2> Related Entries and Links </h2> <div class="panel panel-default"> <div class="panel-body"> <div class="row"> <div class="col-md-12"> No Related Resource entered. </div> </div> <div class="row"> <div class="col-md-12"> <span id="MainCopy_ctl46_ItemRelatedResourcesList_ErrorMessageLabel" class="text-danger"></span> </div> </div> </div> </div> </div> </div> </div> </div> </div></div></div> <div id="MainCopy_extraPanel"> </div> </div> </div> <!--end content--> </div> </div> <div id="MPOuterFooter" class="row siteFrame"> <div id="FOOTER" class="col-md-12"> <div class="row row-last row-wide clearfix"><div class="col-md-12 column section1"><div class="ContentItemHtml"><div class="HtmlContent"><div class="footer"> <div class="footer__left col-sm-12 col-md-8"><nav class="footer__nav"> <ul> <li class="nav-item"><a href="https://www.broadcom.com/products/" target="_blank" rel="noopener">Products</a></li> <li class="nav-item"><a href="https://www.broadcom.com/applications" target="_blank" rel="noopener">Applications</a></li> <li class="nav-item"><a href="https://www.broadcom.com/support" target="_blank" rel="noopener">Support</a></li> <li class="nav-item"><a href="https://www.broadcom.com/company/about-us" target="_blank" rel="noopener">Company</a></li> <li class="nav-item"><a href="https://www.broadcom.com/how-to-buy/sales" target="_blank" rel="noopener">How To Buy</a></li> </ul> </nav> <div class="copyright-text">Copyright © 2005-2022 Broadcom. All Rights Reserved. The term "Broadcom" refers to Broadcom Inc. and/or its subsidiaries. <br />Hosted by Higher Logic, LLC on the behalf of Broadcom - <a href="https://www.broadcom.com/company/legal/privacy-policy" target="_blank" rel="noopener">Privacy Policy</a> | <a href="https://www.higherlogic.com/legal/privacy" target="_blank" rel="noopener">Cookie Policy</a> | <a href="https://www.broadcom.com/company/citizenship/governance-and-ethics#supply" target="_blank" rel="noopener">Supply Chain Transparency</a></div> <div> <ul class="sub-nav"> <li><a href="/termsandconditions">Terms of Use</a></li> <!---<li><a href="#">Sitemap </a> <!--<a href="contactus">Contact Us</a>--></ul> </div> </div> <div class="footer__right col-sm-12 col-md-4"> <ul class="social-nav"> <li><a href="https://www.facebook.com/Broadcom" target="_blank" rel="noopener"> <span class="fab fa-facebook"></span> </a></li> <li><a href="https://twitter.com/Broadcom" target="_blank" rel="noopener"> <span class="fab fa-twitter"></span> </a></li> <li><a href="https://www.linkedin.com/company/broadcom" target="_blank" rel="noopener"> <span class="fab fa-linkedin"></span> </a></li> <li><a href="https://www.youtube.com/user/BroadcomCorporation" target="_blank" rel="noopener"> <span class="fab fa-youtube"></span> </a></li> </ul> </div> </div></div><div class="HtmlFooter"></div></div><div class="ContentUserControl"> <script charset="utf-8">$('.volunteer-opportunities-filter #toggle-button').click(function(e) { $(this).next().slideToggle().toggleClass('js-showFilter'); });</script> </div></div></div> <div id="MPFooter" class="row"> <div class="Footer col-md-12"> <div id="FooterContent"> </div> <div id="MPBottomMenu" class="MPBottomMenu" align="center"> </div> </div> </div> <div class="row"> <div id="MPCopyright" class="col-md-12"> Copyright 2019. All rights reserved. </div> </div> <div class="row"> <div class="col-md-12"></div> </div> </div> </div> <div id="MPFooterLink" class="row siteFrame"> <div class="col-md-12"> <div id="MPFooterLinkContent"> <a href="http://www.higherlogic.com" target="_blank">Powered by Higher Logic</a> </div> </div> </div> <!--mp_base--><div id="GlobalPopupContainer"> <div id="GlobalPopupContent" > <img ID="imgGlobalProcessing" alt="" src="https://d2x5ku95bkycr3.cloudfront.net/img/loading.gif" /> </div> </div> <script type="text/javascript"> //<![CDATA[ var _suppressGlobalPopupContainer = false; Sys.Application.add_load(GlobalApplicationLoadHandler); function GlobalApplicationLoadHandler(sender, args) { var prm = Sys.WebForms.PageRequestManager.getInstance(); if (!prm.get_isInAsyncPostBack()) { prm.add_initializeRequest(initRequest); prm.add_endRequest(endRequest); } } function initRequest(sender, args) { if (!_suppressGlobalPopupContainer) { hl_common_ui_blockUI(); } } function endRequest(sender, args) { hl_common_ui_unBlockUI(); }hl_resourcelibrary.renameBreadcrumbTitle('Shrink the Symantec Endpoint Protection Manager 12.1 embedded database');//]]> </script> <script type='text/javascript'>new Sys.WebForms.Menu({ element: 'AuxMenu', disappearAfter: 500, orientation: 'horizontal', tabIndex: 0, disabled: false });</script> <script type="text/javascript"> //<![CDATA[ $(function() { $('#MainCopy_ctl02_communityJoinLeave_lblLock').popover({title: 'View Only',html: true,container: 'body',placement: 'auto bottom',trigger: 'click hover focus',content: 'Membership is limited.'}); });//]]> </script> <script src="/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ScriptManager1_TSM&amp;compress=1&amp;_TSM_CombinedScripts_=%3b%3bAjaxControlToolkit%2c+Version%3d18.1.1.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d28f01b0e84b6d53e%3aen-US%3ab13aac2d-1c5e-49ed-8aa2-800cbed84558%3acd9be5ef%3adffb332%3a1b51c515%3af2800037%3a2761bb61%3a10439726%3ac99a1521%3a891e6cc6%3a9833e5c%3af06639ea%3a98f9cc63%3adda46be5%3a7b2ffb77%3ad6567903" type="text/javascript"></script> <script type="text/javascript"> //<![CDATA[ Sys.Application.add_init(function() { $create(Sys.Extended.UI.ModalPopupBehavior, {"cancelControlID":"MainCopy_ctl41_CloseButton","dynamicServicePath":"/symantecenterprise/communities/community-home/librarydocuments/viewdocument","id":"MainCopy_ctl41_DocumentLicensePopup","okControlID":"MainCopy_ctl41_BottomCloseButton","popupControlID":"MainCopy_ctl41_DocumentLicenseControllerPanel","popupDragHandleControlID":"MainCopy_ctl41_DocumentLicenseModalPopupPanel"}, null, null, $get("MainCopy_ctl41_TempBtn")); }); //]]> </script> </form> </div> <script> $(document).ready(function () { var path = window.location.pathname; var lastChar = path.substr(-1); // Selects the last character if (lastChar != '?' && lastChar != '/' && lastChar != ';') { // If the last character is not a slash path = path + '/'; // Append a slash to it. } $('ul.navbar-nav a').each(function () { var myHref = $(this).attr('href').split("?")[0]; var lastChar2 = myHref.substr(-1); // Selects the last character if (lastChar2 != '?' && lastChar2 != '/' && lastChar2 != ';') { // If the last character is not a slash myHref = myHref + '/'; // Append a slash to it. } if (path == myHref) { $(this).parents('li').last().addClass('active current-page'); $(this).parent('li').addClass('active current-page'); } }); $('#modalTags').on('tagAdded', function () { var oldCount = parseInt($('#litCommunityTagsCount').text()); $('#litCommunityTagsCount').text(oldCount + 1); }).on('tagRemoved', function () { var oldCount = parseInt($('#litCommunityTagsCount').text()); $('#litCommunityTagsCount').text(oldCount - 1); }); var isImpersonating = false; $(window).bind('scroll', function () { var navHeight = $("#HEADER").height(); // Creating a stickyNav-filler to fill in the position of the stickyNav when it pops out of its position in the DOM to avoid the flicker experience if ($(document).scrollTop() > navHeight) { if (isImpersonating) $('#pnlImpersonation').addClass('sticky'); if ($('.stickyNav-filler').length === 0) { $('#NAV').parent() .append($('<div class="stickyNav-filler"></div>').height($('#NAV').height())); $('#NAV').addClass( 'stickyNav stickyNav-wide '); } } else { if (isImpersonating) $('#pnlImpersonation').removeClass('sticky'); if ($('.stickyNav-filler').length > 0) { $('.stickyNav-filler').remove(); $('#NAV').removeClass( 'stickyNav stickyNav-wide '); } } }); }); //var btn = $.fn.button.noConflict(); // reverts $.fn.button to jqueryui btn //$.fn.btn = btn; // assigns bootstrap button functionality to $.fn.btn </script> </body> </html>