Groups | Blog | Home
all groups > sql server replication > february 2007 >

sql server replication : Backup publisher DB


Paul Ibison
2/26/2007 12:00:00 AM
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

Hilary Cotter
2/26/2007 12:00:00 AM
Yes, but on SQL 2000 you need to make the identity columns, triggers and
constraints Not For Replication.

--
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



[quoted text, click to view]

Marco
2/26/2007 3:59:06 AM
Can I make a backup of my Publisher DB and then restore it on the
Subscriber, or this operation can generate problems?
Marco
2/26/2007 8:51:35 AM
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?

AddThis Social Bookmark Button