Hi All ~

I used the SQL Enterprise Manager to export the database, several
times successfully, between two nodes. During the last two attemps,
the largest table (called item) does not import the data only the
table definition.

There is a item$ table that looks like it's twice the size of the item
table, but that data doesn't apprear complete either based upon some
queries.

Any suggestions?

Also, the application is Microsoft RMS. These backup files are in a
..bck format. Can SQL Enterprise Manager restore this type of file
directly?

hi Jerry,
"Jerry Penna" <jerrypenna@msn.com> ha scritto nel messaggio
news:3ac97809.0410050853.5b78f3a3@posting.google.com
[quoted text, click to view]

you can perhaps have a test using RESTORE LABELONLY syntax to verify the
xx.Bck file IS a SQL Server backup, like explained in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_6hkp.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Thanks Andrea, I'll try your recommendation ~ nice to hear from Italy!
My grandfather/grandmothers homeland (Penna).

I found errors in the import, many similar to this..

"Error at destination for Row Number 33. Errors encountered so far in
this task 1. Unspecified error".

This occurred during the copy data using the step table in about 8
tables out of 30 to 40 tables.

[quoted text, click to view]