| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 18/05/2009 04:30:03
|
EbroIN
Elite SysAider
Joined: 25/03/2009
Messages: 244
Offline
|
Hi,
I've seen there is a backup option available within the integration TAB, but I guess this is only available when using the built in Firebird or Derby DBMS. Is there any way to backup (and restore) all "settings" to a dumpfile when using another DBMS like MS SQL?
Sure, the SQL Servers are backed up, but only backing up the SQL server won't bring up the system as fast as it should be (in case of a disaster).
So having SysAid generating a dumpfile containing all important settings (license, connection information, custom designs, custom messages, stati, translations ... ?) might greatly speed up a disaster recovery.
Is this already built in or should this be a feature request?
best regards,
EbroIN
|
|
|
18/05/2009 05:33:18
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Hello EbroIN.
The current backup module is only available when using the built in database as it has no external backup utility.
In SQL, you can use the integrated backup utility.
Also, it is important to note that the built in backup feature only backup the database and not other files like license and customized files, which need to be backed up manually
Best regards
Haim
|
Pushing IT forward |
|
|
18/05/2009 06:29:42
|
EbroIN
Elite SysAider
Joined: 25/03/2009
Messages: 244
Offline
|
Haim wrote:The current backup module is only available when using the built in database as it has no external backup utility.
...
Also, it is important to note that the built in backup feature only backup the database and not other files like license and customized files, which need to be backed up manually
Thanks for your fast response,
just opened a feature request here!
best regards,
EbroIN
|
|
|
10/03/2010 17:18:11
|
Luis
SysAider
Joined: 23/11/2009
Messages: 11
Offline
|
HI I'M USING MS-SQL DATA BASE, IF MY SERVER HAS A DISASTER, WHAT WILL HAPPEN?  IF I DONT HAVE THE BACK UP UTILITY OF SYSAID.
YOU SAID THE BACK UP UTILITY OF MS-SQL, BUT WHAT EXACTLY I'LL BACK UP? IF ONLY UPLOAD THE DATA BASE BACKUPED TO A NEW SYSAID WHAT WILL HAPPEN?
PLEASE I NEED AN ANSWER.
THANK YOU
|
|
|
11/03/2010 01:05:46
|
JohnE
SysAider
Joined: 09/07/2009
Messages: 45
Offline
|
Luis wrote:HI I'M USING MS-SQL DATA BASE, IF MY SERVER HAS A DISASTER, WHAT WILL HAPPEN? IF I DONT HAVE THE BACK UP UTILITY OF SYSAID.
YOU SAID THE BACK UP UTILITY OF MS-SQL, BUT WHAT EXACTLY I'LL BACK UP? IF ONLY UPLOAD THE DATA BASE BACKUPED TO A NEW SYSAID WHAT WILL HAPPEN?
PLEASE I NEED AN ANSWER.
THANK YOU
Ask your I.T. department to schedule your SysAid database to be backed up regularly, this isn't a SysAid Support question it is a MS SQL support question, if you have to do it yourself then check out MS SQL forums/documentation.
I have a MS SQL backup schedule backup my SysAid DB nightly with 2 weeks retention, and that backup is scheduled to be put to tape nightly.
And please don't post in CAPS as it is difficult to read, thanks.
|
|
|
11/03/2010 03:44:56
|
BJINS
SysAid Wiz
Joined: 08/08/2008
Messages: 583
Location: United Kingdom
Offline
|
Luis,
TO expand on JohnE's response a little:
If you backup through MS-SQL then it will only backup the contents of the database, not your license file or other such data. This you would have to create a separate backup job for manually direct from the folder system ($server-root$\SysAidServer\).
For a complete backup solution I would recommend that you backup the DB through a MS-SQL job, as well as backing up your folder system with your normal backup software.
Does this help Luis?
M
|
When the going gets tough, the tough get SysAid |
|
|
13/03/2010 11:50:17
|
itayH
SysAid Customer Relations
Joined: 23/09/2009
Messages: 1092
Offline
|
Hi Luis,
As the guys here said, the DB backup is only backing up the SRs, users and admins, system settings.
If you want to make a complete backup of the important files, I suggest you back up the following:
..\SysAidServer\root\WEB-INF\conf\serverConf.xml,
..\SysAidServer\root\WEB-INF\conf\activation.xml,
..\SysAidServer\tomcat\conf\server.xml,
..\SysAidServer\root\WEB-INF\classes folder (if any files exists in it).
..\SysAidServer\root\WEB-INF\conf\reports_accountname.xml (if you have customized reports in manager portal)
Also, if you have any customize html or logos.
|
Best Regards,
Itay |
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
![[MSN]](/Sysforums/templates/default/images/icon_msnm.gif){kind=icon}
