Very glad that worked for you and thanks for following up on the post!

Yes.

Seems to be a permissions problem. You can run the following to validate that it has nothing to do with the restore;

RESTORE FILELISTONLY

FROM DISK = N'\\prod_server_name\drive$\sqldumps\prod_db_name.BAK'

If you...

I'm sure someone can come up with something better but for those articles that are critical for us we log the datetime that they were inserted into the publishing database....

You can use tracer tokens for some of this analysis but I'm not sure that will provide you with exactly what you were looking for.

This script is from Hilary...

Phil Factor (2/10/2009)

---

I wrote a blog about this on Neil Davidson's "Business of Software" site. Trust underlies all western commerce. There can never be any compromise in...

This post from Buck Woody explains the report and there is a link on there that refers to the fact that this is part of the plan cache. You will...

It should still only be the one publication on DB1 (primary server) with subscriptions for DB2 (primary server) and DB1 on secondary server. Should work fine.

Glad that NoelD was able...

I'm with Grant, if the right opportunity came up then why not (not me, I couldn't ask for a better place and wouldn't consider looking....).

You do have to be careful...

Dr John Stott

"Nearly all legislation has grown up because we simply cannot be trusted to settle our disputes with justice and without self-interest. A promise is not enough; we need...

If you are really doing a rebuild then you can use the STATS_DATE function to get that information. Other than that, there is no definitive way to get the information...

Ok, understand now. Yes, we do that now, or some variation of that. I was going off the OP question about having to drop the tables as being a requirement....

noeld (2/9/2009)

---

As Long as you are not changing the schema. I believe the 'sync' jobs should apply the "diff" and not drop+create the tables entirely.

There are many solutions that can...

Have you seen somewhere that these are logged events? I don't...

I'm going to try to play with this later today to see what shows up in profiler and I will post back the results (unless one of you fine gentlemen...