SQL 2008 replication

[joblack23]

Is it possible to replicate live SQL data? I have DC 2008 with SQL runing on one of my locations. I will be opening another one and need the live data replicated across then internet. I would perfer not to use remote access for many reasons.

Thanks in advance for any info.

 

[mrdenny]

Yes you can use SQL Server replication on a live database. That's what it was designed for.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog