RL,

I said "SAN" because it really is more of a NAS, it's an

EMC CX 300 sold through Dell

Thanks for your advice.

Mark

Ryan,

If you're refering to SQL 2000, have you ever tried using sp_repladdcolumn?

Mark

One of the considerations with regards to log shipping is the file size of the logs and the pipe with which you are going to be using.  Failover doesn't always...

When you say the agents are running, can you tell me what you are checking to ensure that to be the case?  Thanks.

And you have cooresponding rows in MSRepl_transactions as well?

Is there something you're looking for that running an "sp_help" won't give you?

Mark

Check both sysarticles and syssubscriptions to make sure all of your tables are there. In syssubscriptions, also check the status column for the ones that aren't pushing data.

Make sure...

I have an additional question on this topic. What versions of Windows 2000 will let you enable the 3gb switch? I found this on the Microsoft website:

/3GB

With this...

From what I know, the GUI uses sysindexes to report the row count of a table, that's why you are getting a different number.  However, what is the mystery to...

One last thing, when you ran the UPDATEUSAGE command, did you do a refresh on the table in EM before looking at the properties?

Mark

What does the "rowcnt" column in sysindexes show for that table?

Mark

Next thing to try is a DBCC DBREINDEX on that table and see what happens.

Mark

Run a DBCC UPDATEUSAGE on that table and then do your record count using both methods.  Let us know what happens.

Mark

To get the history from the job step, click the box "Show step details". This hopefully will give you little better info.

Mark

Salim,

I'm not sure if your response is referencing my post, if so, it's not the two slashes at the beginning of the string that's a problem.  You are correct that...