backup commit for query via copy