HELP! Restoration problem

Fisherman

I've exported all of my objects from one server to another. I have verified that the objects were of the versions that I wanted, and imported them.

I deleted my company, and tried to restore a full data backup of the other server. After a period of time, I get a message that I don't understand...

it says "TableData 1000000003 does not exist."

The restore then quits, and the company does not exist.

HELP!

Savatage

Looks like the company can't be saved
http://www.mibuso.com/forum/viewtopic.php?t=11133

but perhaps the backup can help

Native or Sql??
http://www.mibuso.com/forum/viewtopic.php?t=10782

Savatage

Ok I re-read tell me if I got this right
You have 1 computer(1) with the objects you want
you move those objects to the other computer(2), so now they match.
You delete the company from computer(1)
and you're trying to restore the copy made from computer(2) to computer (1)

So you still have the company on computer(2)?

They company that was deleted was a test type database is that why you only changed the objects?

Fisherman

yes - I still have the original server.

Yes. I had syncronized the objects, and was now trying to move the data.

The import manages to run through all the tables. Then, when it actually starts trying to import data... it dies.

Savatage

no message of why - or can you see what's it's on when it dies?

can you file-> database-> test the data on the orig server?

Fisherman

I may be down to that, but it takes so bloody long.

I'm doing a low-level copy (SQL DTS) of the database from the original to my test environment. We'll see what happens there.

If I can get that to work, then I may run the tests tonight.

Alex_Chow

When you do a backup, check OFF the Application Objects.

If you try to restore a full backup with objects, you'll get wierd table ranges.