How to Rebuild GP with only a Company Database Backup no System Database?

(0) Share

Report

Posted on by Rennecia Barran

Hi, I am trying to rebuild Dynamics GP further to a ransomware attack. Unfortunately, all files stored on the storage server were impacted. A backup of the Company database is accessible however I am unable to retrieve a system database backup.

Can anyone advise how to go about rebuilding the Dynamics database to get GP back up and functional?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (8)

Answers (4)

Rennecia Barran on at

Like (0)

Report

RE: How to Rebuild GP with only a Company Database Backup no System Database?

Good Day Forum Team :)

So, I started the rebuild over the weekend.

I used the sp_help GL00100 against the company database and used this to determine the number of segments and the total characters, then did a math calculation to determine the length per segment.

That worked!

I am at the point of re-creating the exchange rate table. I used the MC020102 and MC020103 to populate the MC00100 table in Dynamics. Strange thing is, the primary key in the MC00100 table are Exchange Table, Rate Date, Rate Time. So, I had to do some wild excel calculations to 'remove' duplicates based on this although my data had various rates for the same combination of table, date and time.

I am now rebuilding the exchange table for unposted transactions and then I will tackle the security and test everything.

I vaguely remember the report ID options giving issues from a past client. But I am confident this should all be ready soon.

Will keep you updated! Perhaps it is still below zero :)

Do you all think I am missing anything?

Was this reply helpful? Yes No
Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: How to Rebuild GP with only a Company Database Backup no System Database?

The five biggest steps steps are:

Step 1) Restore your company database to a database of another name.

As Derek suggests

Step 2) Run sp_help gl00100 against your company database. This will give you a good idea of you account format

as Beat suggests

Install GP and run GP Utilities using the account framework from Step1

Step 3)

Create your company using the exact same database name as before

Step 4) Once GP and that database are created use your backup and do a forced restore over the company database you just created

Step 5) Recreate all your users using GP. You will first want to use SSMS to drop all the users from your company database

Keep us posted with your progress. It is below zero up here so no outdoor activities today.

Was this reply helpful? Yes No
Rennecia Barran on at

Like (0)

Report

RE: How to Rebuild GP with only a Company Database Backup no System Database?

Thanks Guys,

I am now looking at working on this rebuild over the weekend. I will be sure to update you as I progress.

Was this reply helpful? Yes No
Verified answer

Derek Albaugh on at

Like (1)

Report

RE: How to Rebuild GP with only a Company Database Backup no System Database?

For this, you could probably use the GL00100 table from one of the company databases, using this script:

sp_help GL00100

What we're looking for is the number of ACTNUMBR_# columns present, which would indicate the maximum number of segments allowed by the original Microsoft Dynamics GP configuration, then using the length of these columns, we can get close to the length allowed for each segment.

I say close, because Dynamics GP adds 1 to any even-numbered lengths, for these columns. So, for example, if I had 10 segments with a length of 6 each, which is the maximum allowed by GP, in the GL00100 and other tables, we'd see columns ACTNUMBR_1 through ACTNUMBR_10, but these columns would have a length of 7, again since GP adds 1 to it.

That being said, this would at least allow to get the maximum account framework, asked about when creating the GP system database, exact on the number of segments allowed and, worse case, within 1 of the segment lengths.

Let us know if you have any questions.

Thanks

Was this reply helpful? Yes No
Verified answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (1)

Report

RE: How to Rebuild GP with only a Company Database Backup no System Database?

To complement what was said, your biggest challenge might be the Chart of Account format (length number of segments, description) which is all stored in the DYNAMICS system database, and not obvious to extract from your GL account table in the company.

The current list of accounts (and format) in the company DB might not be what was initially setup in the original GP installation, and then you might run into some issues with GL transactions.

Was this reply helpful? Yes No
Rennecia Barran on at

Like (0)

Report

RE: How to Rebuild GP with only a Company Database Backup no System Database?

Thank you, I have created a support incident. Posted the query here in case I got feedback before Microsoft's response.

They advised on the Notefix.

I should commence this over the next couple days.

Was this reply helpful? Yes No
Verified answer

Derek Albaugh on at

Like (0)

Report

RE: How to Rebuild GP with only a Company Database Backup no System Database?

I believe you may have a support case open for this question as well, but Richard's information is correct.

With the system database needing to be re-created from scratch, use Dynamics GP Utilities to create it, then also to create a shell company database(s) that you can restore your company db backups into. You'll need to run the script from KB 871973 against those companies to make sure the company id they have, matches what the system db is showing in SY01500 and the SY00100 company table.

You'll need to create the users, user access, and user security, along with any custom SmartLists and SmartList Favorites.

Last is the NoteFix probably needs to be used to set the values in the SY01500 table for each company, to be 1 + the last note value in the company database's tables, for each company.

Thanks

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: How to Rebuild GP with only a Company Database Backup no System Database?

You are going to need to perform a fresh installation of GP and create the company for which you have the backup. You can then do a forced restore of that database. Make sure you specify the exact same gl account framework. If you use notes in GP download the latest NoteFix script you can find.

Was this reply helpful? Yes No