I thought that it might be running the job as one big transaction too. I manually ran the job yesterday instead of letting it run from the schedule and it...

I am running the same thing in QA as I do in the job. I just execute the stored procedure, which does a truncate of each table and then a...

I setup the replication from my subscriber to Oracle in production last night all went well for awhile, but after a few hours the replication failed with this error:

ORA-02291: integrity...

Thanks again for the input homebrew01. I have a play area too, and I plan to do some tests there before going to production. That is where I tested the...

Thank you for the reply. Yes, I know I could have marked the original publication to 'include declared referential integrity', but I didn't. At the time I did not think...

I have a couple of more questions regarding this replication setup.

1. You indicated that by setting up the second publication from the original publisher to the oracle database there...

The SQL Agent is not using 'sa' it uses a windows domain account. Yesterday I decided to try stopping and restarting the SQL Agent service. After doing that my job...

The job is owned by 'sa', but that is why I removed the package and job, then recreated it from scratch after I changed the password. Shouldn't that have resolved...

No, I haven't changed the password for the SQL Agent account.

My manager's main concern is backing up the backup files to tape from the disk. He is concerned that the tape backup could miss or skip a file and we...

Here is the thread that details the similar issue I was having:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=192268#bm192409

I had something similar happen when I changed a database to Bulk-logged recovery mode than ran the optimization task to reindex the database and then I put the database back into...

I asked that same question, and the developers response was that they try to limit direct access to the production database which is currently the publisher. The current subscriber that...

Thank you for your replies. I agree with both of you, and was thinking that the windows administrator could run some reports for the application group on server utilization if...

Colin,

Thanks for the information. Actually, the application support team requested that I just track a single day this week and provide a report of database utilization for the day. I...