2.6

Table Of Contents
ACE Management Server Administrator’s Manual
54 VMware, Inc.
Database Backup
Ifyouareusinganexternaldatabase,useabackupandrecoverystrategythatisappropriateforyourdatabase
system.BackupyourACEManagementServerdatabaseonaregularbasistoensurethatthedatabasecanbe
recoveredpromptlyifneeded.
Ifyouareusingtheembeddeddatabase,youcan
usestandardfilebackuptools,suchasntbackupordd.The
dataisstoredinoneofthefollowinglocations:
WindowsC:\Program Files\VMware\VMware ACE Management Server\db\acesc.bin.
Linux/var/lib/vmware/acesc/db/acesc.bin
Ifyouareusingtheembeddeddatabaseinaproductionenvironment,stoptheserver,copythefiletoa
differentlocationforthebackup,andrestarttheserver.SQLiteisfilebased,sothedatabasefilemightbe
modifiedbytheACEManagementServerprocessatthesame
timethatitisbeingcopiedforbackup.An
inconsistentdatabasesnapshotmightbeproduced.Thisproblemisunlikelytooccurbecausethefileisusually
notlargeandiscopiedquickly.
Otheralternativesforbackingupanopendatabase,asrecommendedbymembersofanSQLitecommunity,
arethefollowing:
Usethesqlite3commandlinetooltologintotheSQLitedatabase.Usethe.dumpcommand,storethe
resultinaseparatefile,andbackupthatresultfile.AnSQLscriptrecreatesthedatabase.
UsetheShadowVolumeCopymechanismonWindowssystemsorLVMvolumesnapshotsonLinux(and
thecrashrestorefeatureofSQLite)tobackupthecompletedatabasedirectory,includingjournalfilesif
theyarepresent.OnaWindowsXPSP1orlateroperatingsystem,usentbackuponthedatabase
directory.
Usethesqlite3commandlinetooltologintotheSQLitedatabase.UsetheBEGIN EXCLUSIVE
command,copythedatabasefile,andthenusetheCOMMITcommand.
Forinformationtohelpyouuseyourcompany’sownmanagementorreportingtoolsorautomatedscripts
withthedataintheVRMdatabase,see
Appendix:DatabaseSchemaandAuditEventLogData”onpage 55.