Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

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!
0
btny
Asked:
btny
1 Solution
 
lcohanDatabase 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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now