August 17, 2001 at 2:47 am
We are replicating a database b/w two sites and have come across the following problem when trying to reinitialize the Subscription at the Publisher.
I/O error 38(Reached end of file.) detected during read of BUF pointer = 0x14247f00, page ptr = 0x15f28000, pageid = (0x1:0x1ff5), dbid = 7, status = 0x801, file = E:\MSSQL7\Data\BI_Data.MDF..
Running SQL Server v7.0 SP 3 Build 7.00.961 on NT 4.0 SP6
Have tried to delete the subscription and get the same error.
Can anyone offer any suggestions. Unable to locate any information on the MSDN knowledge base to help.
Thanks.
Mark
August 17, 2001 at 5:08 am
Looks like you have an actual data or disk error. BI_Data contains your data, is not the distribution db? Tried running dbcc checkdb to repair any errors? If nothing found I'd suggest a support call to MS.
Andy
August 17, 2001 at 3:49 pm
Got a note from Mark today, DBCC fixed it - syssubscriptions was corrupted.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply