Backup creates duplicates

Tonyalmeida

I have created a Geodatabase backup script for my sql geodatabase. Everything runs fine, except for it creates duplicates and adds a 1, 2 ,3 onto the end and i just want it to replace over it. What am I missing?

Here is my current code

import arcpy from arcpy import env   arcpy.env.overwriteOutput = True env.workspace = "C:\Temp\CCAP.gdb"   CCAP = r'Database Servers\DSD15_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)\TonyTwoWay.DBO.CCAP' CCAP2 = "C:\Temp\CCAP.gdb"   arcpy.FeatureClassToGeodatabase_conversion(CCAP, CCAP2)

Image2.jpg

ChrisSnyder

That tool you are using (arcpy.FeatureClassToGeodatabase_conversion) is a bit "weird" in that it attempts to do multiple things at once - create a Geodatabase and then copy featureclasses to it. You might have better luck by being more explicit in what you want to do in your workflow, so for example:

1. Create a FGDB
2. Copy your features to it using the CopyFeatures tool.

Perhaps you can add some logic as to what to do if these items already exists.

Not sure why arcpy.env.overwriteOutput = True isn't working properly for you. Do you have a lock on the FC or FGDB?