SQL 2005 restore error 4902

Dave_Cintron

Can anyone help explain this message which occurs at the end of a restore of a company with VERY little data?

The message follows table and key creation. Going into SQL Mgmt studio shows the table DOES exist both as table 7 and as 100000007 so it must be permissions. I am logged in as sa (dbo).

The following SQL Server error(s) occurred while accessing the Standard Text table:

4902,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "MCB51.dbo.Greenleaf$Standard Text" because it does not exist or you do not have permissions.

SQL:
ALTER TABLE "MCB51"."dbo"."Greenleaf$Standard Text" ADD CONSTRAINT "Greenleaf$Standard Text$0" PRIMARY KEY CLUSTERED ("Code")

ara3n

It looks like you didn't finish the restoration. Click on tools and restore and it will ask you to continue finishing the restoration.

Dave_Cintron

Buddy, I've been working with SQL on NAV for 8 years, so I really need a better answer than "Installation 101".

DenSter

Answers like that are not conducive to a community spirit Dave, there's no need to bite someone's head off for suggesting something you've already thought of yourself. We're all thinking with you, and it's not always clear to estimate someone's proficiency level. A better way to apporach this would have been "Yes I thought about that too, so I checked (because we always doublecheck ourselves right ). It has to be something else". Then again, your reply could be totally in gest, it's not always easy to tell.

MY 2 cents: it might have something to do with your backup not including application objects.

David_Singleton

Dave Cintron wrote:

Buddy, I've been working with SQL on NAV for 8 years, so I really need a better answer than "Installation 101".

:evil:


And in those 8 years did you ever find a way that a 100,xxx,xxx table could exist EXCEPT from an incomplete restore?

Dave_Cintron

This error was solved by recompiling all of the tables AFTER importing the backup. Because the restore refused to complete, giving the error described in the first post, this recompile had to be done BEFORE the restore would complete.

I would like to know if anyone else is running into this bizarre behavior in SQL 2005 with the 5.0 SP1 client.

ara3n

were the objects in the db by any chance different than the backup?

Dave_Cintron

Absolutely not. This was a database created from scratch on a brand new install of SQL 2005. The Navision database was backed up and restored in the same hour.

garak

i'm right that you are restore an fbk :?:

mark0038

We had the same problem. Here the solution:
You have object in the database how are compiled in a older version of Navision. Mark all objects and compile them. Then it works for sure
Mark