Configure a SQL 2008 Replication job (Copy a databse and replicate to it)

Hi There,

I want to make a copy of a SQL database and replicate data from another database to it continously.  

So lets say I have production DB, I want to copy that and replicate to it and call it DevDB.

Please advise on how to do this in SQL 2008 and any gotchas or issues in doing this.

Thanks!
btnyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
lcohanConnect With a Mentor Database AnalystCommented:
"I want to make a copy of a SQL database"
You can use "Copy Database" task under SSMS, right click the DB you want to copy, and select the option from the "Task" menu that pops up.
http://msdn.microsoft.com/en-us/library/ms188664(v=sql.100).aspx

" replicate data from another database to it continuously. "
I suggest you setup a Transactional Replication
http://technet.microsoft.com/en-us/library/ms151706(v=sql.100).aspx
http://technet.microsoft.com/en-us/library/ms151254(v=sql.100).aspx

but if you really rally need "continuously" then see if Mirroring can serve your purpose:

http://blogs.technet.com/b/meamcs/archive/2010/12/04/sql-mirroring-amp-replication.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.