How do I backup the Primary Events Manager Database / SQL Backup Issues
|
Logged in as: Guest
|
|
Users viewing this topic:
none
|
|
Login  | |
|
How do I backup the Primary Events Manager Database / S... - 26.Jun.2008 3:16:08 PM
|
|
|
Looking4Answers
Posts: 38
Score: 0
Joined: 24.Nov.2006
Status: offline
|
What is the approved / supported method to complete a SQL database backup of the Main Events Manager Database?
I am currently running EM 8.1 Build number 20080318 on four 2003 Servers running SQL 2005. Multiprocessor servers 8+ Gig RAM with only EM running on it. Anti-Virus is not scanning EM file folder or databases. I cannot send you any logs.
I have scheduled a sql job complete the following Steps:
1. net stop "GFI Eventsmanager"
2. run sql backup
3. net start "GFI Eventsmanager"
For the net stop or net start processes, sql makes a call the cmd line in step 1 and 3 as listed above. 90% of the time the commands execute and reports failure. Although it reports failure sometimes the GFI Events Manager service starts or stops in accordance to the command. In a sql job typically when a job step fails you have the job set to stop and fail. I can duplicate the cmd call issue outside of a sql job from the cmd line directly. I have tried to complete sql flat file backups without stopping the service back in EM7 2006 builds and the database didn't like this. EM would start throwing errors. From a history aspect, issue described above has been happening since the EM7 2006 builds for me but before EM 8.1 it was happening about 1 time every 3-4 months. Now it happens daily. From talking to support I am not the only customer. Please provide some direction.
Thank you
|
|
|
|
|
RE: How do I backup the Primary Events Manager Database... - 3.Jul.2008 9:04:53 AM
|
|
|
DrewE
Posts: 436
Score: 0
Joined: 28.Apr.2008
From: Cary, NC
Status: offline
|
One option would be to monitor the net stop command for failures, when it has failed, use an application like PSKill to terminate the esmproc.exe file manually. This will terminate the GFI EventsManage service, although not gracefully. This process would not be supported by GFI, but should work in your scenario.
_____________________________
Drew Easley - Technical Support Representative
GFI Software - www.gfi.com
|
|
|
|
|
RE: How do I backup the Primary Events Manager Database... - 3.Jul.2008 10:48:16 AM
|
|
|
Looking4Answers
Posts: 38
Score: 0
Joined: 24.Nov.2006
Status: offline
|
So I have two questions. . .
- What is the approved / supported method to complete a SQL database backup of the Main Events Manager Database?
- Is there a problem with the GFI Service? (Is this reproducable from outside of my environment)
|
|
|
|
|
RE: How do I backup the Primary Events Manager Database... - 15.Jul.2008 3:00:16 PM
|
|
|
DrewE
Posts: 436
Score: 0
Joined: 28.Apr.2008
From: Cary, NC
Status: offline
|
I have not heard of any other cases regarding this service issue.
The official recommendation if you are backing up your SQL database would be, as you are trying to perform, to stop the GFI EventsManager service, backup the database, and then restart the service.
_____________________________
Drew Easley - Technical Support Representative
GFI Software - www.gfi.com
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
 Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts |
|
|
Printable Version
