Subscriptions while server offline

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Subscriptions while server offline

Author

Topic

derbya
Starting Member

5 Posts

Posted - 2008-06-03 : 13:53:24

Hi,

If you have many recurring report subscriptions created and the server will be offline for say maintenance, is there an easy way to process any subscriptions that were missed while the server was offline?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-03 : 14:01:10

You just need to bring the server back online and then replication will take care of it. The data will be held in the publisher's transaction log while the subscriber is offline, so be aware of the disk space implications.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

derbya
Starting Member

5 Posts

Posted - 2008-06-03 : 14:47:15

Hi,

I should have said, the Reporting Services database and the webserver are on the same physical box.

Thanks

Adam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-03 : 14:49:54

That doesn't matter. Replication will sync everything up once the SQL Server Agent service starts since replication is handled through jobs.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

derbya
Starting Member

5 Posts

Posted - 2008-06-03 : 14:56:38

So is this out of the box functionality or does the replication need to be set-up?

If you can point me to any documentatin that would be great?

and thanks for the quick responses.

Adam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-03 : 15:06:23

I'm sorry. I competely misunderstood your issue. I thought you were talking about replication. I now see that you are talking about Reporting Services per the forum you chose. Please ignore my comments.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

derbya
Starting Member

5 Posts

Posted - 2008-06-03 : 20:01:58

So now you understand my original question, any thoughts?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-04 : 12:43:22

I would provide thoughts if I had any about this topic.

But sadly I don't have the knowledge required to answer your question.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources