Friday, March 9, 2012

Freeze replication

I would like to do a backup of a publishing database and restore as opposed
to syncing from scratch that might take a long time for a huge database. In
order to do so, I would like to freeze changes made at the publisher
somehow... backup the database after its frozen, restore the database
establish replication and then unfreeze.
Ive read some google posting a year ago on some ways of achieving that
freeze by running selects with tablockx hints.. Im not 100% certain but
either would like to know more about how to freeze it.. I am willing to
accept blocked transactions and timeouts at the time...
This is more from a DR restore perspective.Using SQL 2000
put your database in read only mode, do your backup, and then restore it on
the subscriber.
This way you are guaranteed to have a consistent publisher and subscriber.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uyoTWyelEHA.3428@.TK2MSFTNGP14.phx.gbl...
> I would like to do a backup of a publishing database and restore as
opposed
> to syncing from scratch that might take a long time for a huge database.
In
> order to do so, I would like to freeze changes made at the publisher
> somehow... backup the database after its frozen, restore the database
> establish replication and then unfreeze.
> Ive read some google posting a year ago on some ways of achieving that
> freeze by running selects with tablockx hints.. Im not 100% certain but
> either would like to know more about how to freeze it.. I am willing to
> accept blocked transactions and timeouts at the time...
> This is more from a DR restore perspective.Using SQL 2000
>

No comments:

Post a Comment