Navision error

We just restore our MS-Sql DB server and Wee are getting error at the time of search and detail in attached file,  kindly help on this.
1.JPG
2.JPG
3.JPG
sitgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepak ChauhanSQL Server DBACommented:
Connect SQL server using ssms and check database, it should not be in Inconsistent state after restore,
Second, Check your database by executing the DBCC command.

use < Database Name>
go

DBCC checkDB()

If you are connected MS Dynamic using sql users, check it should not be unmapped with login.

use <databaseName>
go
exec sp_change_users_login 'report'
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Why did you restore the database?
It was a server migration? A version upgrade? The database was corrupt or you just lost the database?
0
sitgAuthor Commented:
server was crashed due to hardware failure
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you reinstall the server? SQL Server included? If so you may miss some SQL Server login or permissions.
Check in the database if all users are properly matched with the expected logins.
0
sitgAuthor Commented:
I got the attached error when run DBCC checkDB()
nav-odbc-error.txt
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
When did you perform the backup? Hope wasn't during the server crash.
0
sitgAuthor Commented:
actually DB and rest  servers  managed by other team and  we are not able to restore database from backup because  all backup compressed file is corrupted
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
You have a very bad scenario there. When was the last known good backups?
0
Deepak ChauhanSQL Server DBACommented:
If you dont have good backup, you have to repair this database and some chances for data lose.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NaviWorldSGCommented:
Not sure if you still want any advise on this matter. The Navision classic does have a feature that at least gives the user some idea as to what the issue is in certain data corruption/inconsitenance issue. At that point, the user can then read and hopefully patch the data.

Steps to run feature:
1) Login to Navision.
2) Press Alt + F. Then press B. Then press T.
3) You will see a form called Test Database.
4) Click on the Radio button Maximum.
5) Click on the tab Options.
6) Then select the radio button File.
7) Select a file location and file name.
8) Click the OK button and it will run for the database.
9) Assuming that there are drastic errors, you should be able to see the text file with issues.

If you get too many error messages, you may want to consider patching the database  from the SQL. MS SQL is not my expertise so you will need some other expert to assist.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.