Showing posts with label replications. Show all posts
Showing posts with label replications. Show all posts

Tuesday, February 21, 2012

replications fails to bulk copy out of table.

In the last two weeks the scheduled replication has
failed on the same table. Our programmer has not changed
the table. Manual replications are successful.
Error message: The process could not bulk copy out of
table '[dbo].[syncobj_0x4436433341414546]'.
Error details: I/O error while writing BCP data-file
(source: ODBC SQL Server Driver [ODBC]; Error number: 0)
this is an OS level problem. Do you have disk space problems? Hard disk
problems? Is this error reproducible?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Belen" <anonymous@.discussions.microsoft.com> wrote in message
news:313001c470e1$6f7c5bf0$a501280a@.phx.gbl...
> In the last two weeks the scheduled replication has
> failed on the same table. Our programmer has not changed
> the table. Manual replications are successful.
> Error message: The process could not bulk copy out of
> table '[dbo].[syncobj_0x4436433341414546]'.
> Error details: I/O error while writing BCP data-file
> (source: ODBC SQL Server Driver [ODBC]; Error number: 0)
>
|||There is enough disk space on the server. The problem
has corrected itself but what could have been the problem.
>--Original Message--
>this is an OS level problem. Do you have disk space
problems? Hard disk
>problems? Is this error reproducible?
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"Belen" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:313001c470e1$6f7c5bf0$a501280a@.phx.gbl...
changed[vbcol=seagreen]
0)
>
>.
>
|||I don't know. Other people have reported it. Perhaps an aggressive
anti-virus software.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
<anonymous@.discussions.microsoft.com> wrote in message
news:6c2301c475a9$63782ec0$a301280a@.phx.gbl...[vbcol=seagreen]
> There is enough disk space on the server. The problem
> has corrected itself but what could have been the problem.
> problems? Hard disk
> message
> changed
> 0)

replications and stored procedures and sa account

I have just setup my first Transactional replication between twoservers. Next I needed to test what would happen if the live serverwent down.
I disconnected the live server and connected it to the backup server(doing all the ip setup bits as well). Then I tried running my web app.
The web app ran great. I can look at the data that was replicated. Myproblem is that I cannot seem to add any data. Ever time I try to run astored procedure, the web app crashes with 'sa' account login failed. Itried running the stored procedures through SQL Query Analyzer, and itsays the same thing.
I know there is no problem with the sa account, as I can view the datausing this. There are no permissions set on any of the objects in thedatabase. The only thing I can think of is that the replication hassomehow disabled the ability to add data to the replicated database.
Can anyone point out what is happening?
Foundan MSDN article which explains why this is happening. Solve the problem.

Replications

I want the replication b/w Access to MySQL... can any one let me know the
tool ....
> I want the replication b/w Access to MySQL... can any one let me know the
> tool ....
Check http://vyaskn.tripod.com/repl_ans5.htm.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com