Backup publisher DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marco - 26 Feb 2007 11:59 GMT

Can I make a backup of my Publisher DB and then restore it on the
Subscriber, or this operation can generate problems?

Reply to this Message

Paul Ibison - 26 Feb 2007 12:51 GMT

Marco,
if you are using sql server 2005 you can use the option to "initialize with
backup". If not then you can do a nosync initialization. Once done, you'll
need to remove identity attributes for a nosync initialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Reply to this Message

Hilary Cotter - 26 Feb 2007 13:08 GMT

Yes, but on SQL 2000 you need to make the identity columns, triggers and
constraints Not For Replication.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Can I make a backup of my Publisher DB and then restore it on the
> Subscriber, or this operation can generate problems?

Reply to this Message

Marco - 26 Feb 2007 16:51 GMT

Tanks for your answers.

I'm using SQL 2000; I have not understood very well the correct
procedure.
I have only few tables, every table has a unique identifier, no
dependencies, no idexes, no triggers.
If simply I export all data in tables, for example in .txt files, and
then I reimport the data in the other DB?

Reply to this Message