AnsweredAssumed Answered

How do I maintain two copies of an ArcSDE database in a SQL Server instance?

Question asked by conorbarber on Mar 17, 2015
Latest reply on Mar 17, 2015 by conorbarber

I want to maintain two identical copies of an --unversioned-- ArcSDE database in the same SQL server instance (a QA and a production database). ESRI documentation notes that you cannot rename a SQL server database when copying it. What is the recommended way to make a scheduled copy of an ArcSDE SQL Server database in a single instance?


I have access to the full range of SSMS tools and SSIS as well as ArcInfo license, ArcPy and ArcEngine.