all groups > sql server replication > april 2007 >
You're in the

sql server replication

group:

SQL 2000 Replication: Could not bulk copy out of table



SQL 2000 Replication: Could not bulk copy out of table Mark Alejandro
4/26/2007 8:44:03 AM
sql server replication: we are running sql200 and i am trying to do a transactional replication, i
recieve the following error message during snapshot creattion

The process could not bulk copy out of table
'[dbo].[syncobj_0x4336423045343434]'.

The error detail follows:

I/O error (torn page) detected during read at offset 0x00000565a94000 in
file 'D:\MSSQL\Data\jde_PRODUCTIONdata.mdf'.
(Source: JDESERVER (Data source); Error number: 823)

ive done a dbcc checkdb and it fails with the same error.....

any help would be greatly appreciate
RE: SQL 2000 Replication: Could not bulk copy out of table Paul Ibison
4/26/2007 9:44:02 AM
If you have a valid backup then I'd restore it and then run a dbcc checkdb.
If not, then you might need to consider emergency mode (ring PSS but look at
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp and
http://www.devx.com/vb2themax/Tip/18624 to see what it's about).
Cheers,
AddThis Social Bookmark Button