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
 SQL Server 2008 Forums
 Replication (2008)
 Database Replication

Author  Topic 

mbehring
Starting Member

4 Posts

Posted - 2012-01-05 : 17:16:04
Hi all,

I need to create a Replication for some Databases. I already have a new SQL 2008 R2 Server installed and running...with NO databases on it (except the default installation ones).

Do I need to copy the databases I want to replicate to the new server before configuring the actual replication?

Any help is appreciated.

Mario

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-01-05 : 17:22:33
No, you would need to create the database container, but replication can create the other objects. We only replicate tables, and only a subset. Anything else we need, we run a script to create them (such as views, stored procedures, static tables, ...).

But you can copy them if you want. It would certainly speed up the snapshot.

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

Subscribe to my blog
Go to Top of Page
   

- Advertisement -