Error using the Export Database Wizard to export store database in

I had this problem shortly after upgrading to 2.0. Running a db re-index then a db check from HQ admin resolved it.

"LLoyd" wrote:

Re-indexing an a db check were the first tings I did. They were unsuccessful of course.

Any other suggestions?

Lloyd

"Daniel S." wrote:

Lloyd did you ever get this resolved? I ran into this same issue today. Reindex and Check did not solve the problem. My workaround was creating a store ops template db from a blank store ops db instead of an actual store ops backup; the way I understand the process is the template sends to your exported db "store specific" info like register settings, templates, security, etc., - whereas the HQ db sends "centrally maintained data" like items, departments, suppliers, etc to the exported db. Using MS Access we then copied contents of security table into the blank security table in our exported db....seemed to do the trick but made a two minute process feel like two hours......

Later I found KB862876 that > Re-indexing an a db check were the first tings I did. They were unsuccessful

I'm trying to create a store database for a new store in HQ. When the process is exporting the data, it gets as far as the Item table and I receive the error:

Export Database Wizard: An error was encountered while exporting data. Your Store Operations database is not complete and may not work correctly. Error 0:

I have tried it twice and I get the same error. Any clue what is going on here?

I am using RMS/HQ 2.0 SP1 and SQL Server Standard 2005 SP2 with WinXP SP2