Export - Import Failing on One Table

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?
Jerry
hi Jerry,
"Jerry Penna" <jerrypenna@.msn.com> ha scritto nel messaggio
news:3ac97809.0410050853.5b78f3a3@.posting.google.c om
> Also, the application is Microsoft RMS. These backup files are in a
> .bck format. Can SQL Enterprise Manager restore this type of file
> directly?
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/de...ra-rz_6hkp.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<2sg22pF1l010eU1@.uni-berlin.de>...
> hi Jerry,
> "Jerry Penna" <jerrypenna@.msn.com> ha scritto nel messaggio
> news:3ac97809.0410050853.5b78f3a3@.posting.google.c om
> 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/de...ra-rz_6hkp.asp
|||hi Jerry,
"Jerry Penna" <jerrypenna@.msn.com> ha scritto nel messaggio
news:3ac97809.0410051757.75ce90e4@.posting.google.c om
> Thanks Andrea, I'll try your recommendation ~ nice to hear from Italy!
> My grandfather/grandmothers homeland (Penna).
=;-D

> 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.
it's actually very difficult to give an advice in this situation... if you
can verify the table causing problems you can eventually check the data
stored in it and possibly perform a DBCC CHECKTABLE on it...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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