Microsoft Dynamics AX (Archived)

SQL backup Success . not affected in AX

(0) Share

Report

Posted on by shuhaib

339

Hi ,

There was a upgrade of the R2 cu6 to R3 Cu10 .the live server is working fine .

For test server our plan was to install R3 Cu10 from scratch and backup the database .

the backup is complete and data is displaying in DB , but its not affected in ax

Please help me to resolve the issue

Thanks

shuhaib

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (1)

André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi Shuhaib,

Can you tell if you only restored the data database without the model? This is not possible as the environments do have their own different element ID's.

You need to follow the steps as described in the AX 2012 Upgrade guide.

Was this reply helpful? Yes No
shuhaib 339 on at

Like (0)

Report

Hi

I have back up model data base also

But not working

Was this reply helpful? Yes No
Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

I assume you meant restoring a database. Just creating a backup file obviously doesn't move data to any AX environment.

Did you restore both databases (data and modelstore)?

Was this reply helpful? Yes No
shuhaib 339 on at

Like (0)

Report

Hi

I have restored both the database

Is there anything other than restore we have to do so that the data is present in ax

Was this reply helpful? Yes No
André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi Shuhaib,

Can you provide some more background information? Is the AOS running correctly? Is it running using the correct database parameters? Are you connecting with the correct AX client settings? Did you actually stop the AOS during the restore procedure?

Was this reply helpful? Yes No
shuhaib 339 on at

Like (0)

Report

AOS is running correctly . i have back up the database name given while installing

i am working in the test server itself and i am connecting to thecorrect client . i have stopped the AOS while back up

Was this reply helpful? Yes No
shuhaib 339 on at

Like (0)

Report

I have installed R3 cu10

After all the checklist is performed I restarted SQL and stopped ax services and restored the both database .

The data is not populating in the new environment

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

can you open AX Client at server (where you restored DB) ..??

If you can open AX Client, can you navigate to following form to know Connected AOS Information

System Administration >> Setup >> System >> Server Configuration

Was this reply helpful? Yes No
shuhaib 339 on at

Like (0)

Report

Hi shoib

I can navigate

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

so, are you able to see your accurate AOS there?

in addition open AOT, have a look into few tables randomly can you see data there in tables?

also please have a look at following screen to know which database it is connected to

System Administration >> Inquiries >> Database >> Database information

Was this reply helpful? Yes No