What kind of replication are we talking about? I assumed it was transactional...and if you restarted the snapshot agent it would have automagically resnapped the entire table and everything...

What errors are you getting?

Also, what result do you get after running DBCC CHECKTABLE( 'YOURDB') WITH ALL_ERRORMSGS , NO_INFOMSGS on the subscriber?

If it's imported to Excel why not leave the format alone as you pull it out of SQL Server and have a macro in Excel to do all the formatting...

Glad it helped 🙂

What about when you turn on the extra logging?

You can try to log more contents of the failing Agent job but opening up the Job, going to the Step (should...

+1 Gila...she beat me to the draw!

penu.v8 (11/20/2012)

---

hmm.. welll need to dig into that since the full back up too writing to the same folder..

i dont understand err:

Problems with the query, "ResultSet" property not...

Also, which Service Pack do you have installed?

Did any permissions change? Perhaps with your Tech Services team? Was the account being used to execute your SQL Agent jobs recently change? Perhaps it was in the local...

So this used to work before? Sorry if i misunderstood your original post...

Since it works when you run it manually, it makes me think that the execution/proxy account for...

Yes, but...

Try executing it via a query window, also, have you verified no errors in the System Event Viewer? One last thing, are you 100% positive there is adequate space...

Try running the actual TSQL needed to run the backup from SSMS, the error outputted by the SQL Agent job isn't always very descriptive. Also in the past, I've...

How about SELECT CONVERT(VARCHAR(25), GETDATE(), 22)

No problem, hope it works out for you 🙂