2.5

Table Of Contents
ACE Management Server Administrator’s Manual
74 VMware, Inc.
Database Backup
Ifyouareusinganexternaldatabase,useabackupandrecoverystrategythatis
appropriateforyourdatabasesystem.BackupyourACEManagementServerdatabase
onaregularbasistoensurethatthedatabasecanberecoveredpromptlyifneeded.
Ifyouareusingtheembeddeddatabase,youcan
usestandardfilebackuptools,such
asntbackupordd.Thedataisstoredinoneofthefollowinglocations:
WindowsC:\Program Files\VMware\VMware ACE Management
Server\db\acesc.bin.
Linux/var/lib/vmware/acesc/db/acesc.bin
Ifyouareusingtheembeddeddatabaseinaproductionenvironment,stoptheserver,
copythefiletoadifferentlocationforthebackup,andrestarttheserver.SQLiteisfile
based,sothedatabasefilemightbemodifiedbytheACEManagementServerprocess
atthesame
timethatitisbeingcopiedforbackup.Aninconsistentdatabasesnapshot
mightbeproduced.Thisproblemisunlikelytooccurbecausethefileisusuallynot
largeandiscopiedquickly.
Otheralternativesforbackingupanopendatabase,asrecommendedbymembersof
anSQLitecommunity,arethefollowing:
Usethesqlite3commandlinetooltologintotheSQLitedatabase.Usethe.dump
command,storetheresultinaseparatefile,andbackupthatresultfile.AnSQL
scriptrecreatesthedatabase.
UsetheShadowVolumeCopymechanismonWindowssystemsorLVMvolume
snapshotsonLinux(andthecrashrestorefeatureofSQLite)tobackupthe
completedatabasedirectory,includingjournalfilesiftheyarepresent.Ona
WindowsXPSP1orlateroperatingsystem,usentbackuponthedatabase
directory.
Usethesqlite3commandlinetooltologintotheSQLitedatabase.Usethe
BEGIN EXCLUSIVEcommand,copythedatabasefile,andthenusetheCOMMIT
command.
Forinformationtohelpyouuseyourcompany’sownmanagementorreportingtools
orautomatedscriptswiththedataintheVRMdatabase,see
Appendix:Database
SchemaandAuditEventLogData”onpage 75.