Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SD 5.0 SP1 Backup & Restore

Highlighted
Back2Future
Super Collector

SD 5.0 SP1 Backup & Restore

Hi!

I have the following configuration:

- a test installation of SD 5.0 Sp1 to develop forms, actions and so on;

- a production environment of SD 5.0 Sp1.

Is there any way to make a copy of the whole configuration of test environment to the production environment, to have the same situation on the two servers?

By the way .. the two machines have different hostname .. is it a problem for SQL database of SD?
6 REPLIES
Mark O'Loughlin
Honored Contributor

Re: SD 5.0 SP1 Backup & Restore

Hi,

the main thing is to make a copy of one database and have the application server access it.

It is advisavle to make a copy of the production database and have the test environment access that copy (not the other way around as you mention above).
David Borojevic
Frequent Visitor

Re: SD 5.0 SP1 Backup & Restore

Mark is right.

When developing, make a copy of Production and develop against that db copy. For large critical installs have another copy of Production to test the "release" of your development work to this test copy then if this tests OK then you can better guarantee the release to Production.

Be careful that emails don't fire from the Development database when you take a copy - ie break the email settings or point them to an smtp server that can collect all the outgoing emails into a single mailbox for testing email rules.

Also becareful with Codes and enure that codes only ever get made in one side and get ACED between them as there are UIDs and so if these get stuffed up then the Business rules etc that might use them in criteria can be stuffed up also.

Cheers
Back2Future
Super Collector

Re: SD 5.0 SP1 Backup & Restore

So .. what is the best disaster recovery plan for Service Desk 5.0 Sp1?

Is it enough to make a whole backup of the entire SQL Server instance?
David Borojevic
Frequent Visitor

Re: SD 5.0 SP1 Backup & Restore

I can confidently say that for v4.5 - yes a normal SQL backup contains both data and configuration (forms, business rules, etc - everything in the System Console) and so is good for DR.

You would of course need (written down) the details required to rebuild the connection between the App server and the DR Database server - ie. everything in the Server Settings Editor.

I'm pretty sure that SD5 still has a single SQL database that contains data and config. You could look - unless the naming standard has changed the tables with ITSM_ are generally data and REP_ are generally config. But the exact separation isn't quite that simple?

Cheers
Mark O'Loughlin
Honored Contributor

Re: SD 5.0 SP1 Backup & Restore

Hi,

Also, be sure to back up the application servers and server that has e.g. Service Pages installed. You also need to be able to restore these quickly with their current setup.
David Borojevic
Frequent Visitor

Re: SD 5.0 SP1 Backup & Restore

Oh yes and you will also need to ensure the FTP site that stores the attachments is backed up. I assume that if the FTP site is specified in the Attachment Settings is done via a DNS entry rather than using the machine name, moving the FTP location (eg in a DR situation) would be easier.

I have just realised that we have used the App server name - damn.

Cheers
//Add this to "OnDomLoad" event