How to re-establish subscriptions DB using Backup of Subscriber Db?

BOL 2000 makes reference to recovering a subscriber DB using a backup of the subscriber DB but does not appear to say how to go about doing it. What I need is enough info on how to set-up a backup and recovery strategy that can be implemented in a production environment. Snapshot recovery is no longer acceptable and there are lots of identity columns. Push publication.

It should be rather cook-book and I am hoping you can point me to a doc that will allow me to achieve this. It should be rather cook-book and I am hoping you can point me to a doc that will allow me to achieve this.

Thanks

Michael

Hi,

This KB article lays out the steps required to setup subscription using backup: http://support.microsoft.com/kb/320499.

Peng

|||

The article you referenced does not address using Subscriber backups. Only Publisher backups. A nice idea, but not what I asked for.

Thanks

|||

OK. So I assume you are looking for a recovery plan for your subscription database. You can take a look at the documents in SQL 2005 BOL http://msdn2.microsoft.com/en-us/library/ms152560.aspx. I know it is not exactly what you ask for because the document it is for SQL 2005. But they are very close. Basically, the steps are as following:

1) check if the backup is older than the retention period. If yes, reinit the subscription. Otherwise, goto next step

2) restore the backup

3) If you have pull subscrption, check it. You may need to reinit if the subscription information is not up-to-date

4) restart the distribution agent

Peng

sql