Thank you both for your replies and suggestions. Actually the problem was related to a File Transfer Protocol task that was in the packages. Once I replaced that with an...

Are you saying the transactions are rolled back at the publisher? I'm not sure that is the issue, since there was a clean reboot the night before last. The problem...

I dropped and recreated the snapshot publication. Last night the replication ran normally and the snapshot agent took about 13 minutes to complete. The servers also went through a clean...

Yelena,

Thanks so much for the additional information and links. Yes, I know you're right that it would do me good to work on the script and become more proficient in...

Hi Yelena,

Thanks for the reply and yes, that's exactly what I want to do. Unfortunately, the current script writes to a text file but just writes a 0 for failure...

Yelena,

Thanks for the response. What we are trying to do is verify that the SQL Server instance is up and that we can connect to it. What we currently have...

I was able to gather some more information, and actually this problem has been resolved. It seems the foreign key existed on the tables at the subscriber sites. The problem...

Thanks Brian, you cleared that up for me. Currently we have the service accounts set up with a domain account and in the administrators group. For our new setup we...

Thanks for the information. From the link you provided there was this bullet:

If the service account for SQL Server is not an administrator in a cluster, the administrative shares...

Thanks for the response. I think you have identified what my problem is. I have decided to use a different stored procedure though, because this one assumes that reindexing a clustered...

I found the stored procedure on a sqlserver performance website and made some modifications to it. The original stored procedure was actually checking for a hardcoded logical fragmentation value, but...

Thanks for the reply. Actually, to troubleshoot this I changed the status to different numbers to figure out where it was actually falling through to and it is going to...

Erich,

We recently did something similar. We needed to move the data from two columns of a SQL Server table to an Oracle database for code lookups. We orignially set up...

Rudy,

I am not familiar with the MSX/TSX server setup. Where can I get information on that? Does it come with SQL Server?

Thanks,

Michelle

Thanks for your response. Actually, since I posted the thread I have decided that I am going to remove both log shipping and replication (after I generate the sql script...