@sql Galaxy - you should be able to change the script to easily monitor a single server

jonathan.hickford (2/2/2015)

---

Thanks for posting!

I've seen a few different change tracking systems, some using the default trace, and others using DDL triggers/ What are your (and others) thoughts about...

No problem, glad that helped

That's because you are serving them the wrong link 😀

My guess is you are giving them the web service URL - something like:

http://<<SSRSServerName>>/ReportServer

But you should be using the Report Manager...

Did you enabled the TCP/IP protocol in the SQL Server Network configuration?

No, there is no dependency on IIS for reporting services whatsoever

If you are hosting this link from a web application, then the web application will/should have its own application...

@Siberian - I've got an article being published next week here on SSC that you can use to keep track of those events - I believe it comes out on...

Personally I would start over again and not used the backup and just go with snaphots (I say this ONLY because I've never had any luck with the restore); however...

I do not have much successful experience with restoring from the backup method. Actually i've never gotten it to work successfully!

But to take a stab at it, you'll...

I'm pretty confident it" did not break anything, but your previous snapshot that you created (yesterday) might not have completed yet so it has some lingering actions that it's trying...

adding the article should be quick, providing the immediate_sync and anonymous setting are set to 0 (using the script provided)

You can then start the snapshot agent at an appropriate time...

steve.roberts 86619 (1/28/2015)

---

This is the results, the bottom one is the publication in question.

So I guess it is trying to generate a complete snapshot straight away? If I disable this...

Sounds like the result of the query I just added...

Also since you're using the GUI, on your distribution server what is the result of running the query below?SELECT publisher_id, publication_id,

publisher_db,

...

check your running processes by selecting from sysprocesses or run sp_who2, etc

To clarify, have you already run this and it is still going? or is this more of a curiosity...