# Deleted Docs - SQL SYNC

**URL:** <https://discuss.elastic.co/t/deleted-docs-sql-sync/312153>\
**Category:** Logstash\
**Created:** [August 16, 2022, 8:57am UTC](https://discuss.elastic.co/t/deleted-docs-sql-sync/312153 "2022-08-16T08:57:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Berat\_Demirci](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/berat_demirci/32/109625_2.png) [@Berat\_Demirci](https://discuss.elastic.co/u/Berat_Demirci)\
**Post date:** [August 16, 2022, 8:57am UTC](https://discuss.elastic.co/t/deleted-docs-sql-sync/312153/1 "2022-08-16T08:57:41Z")

</div>

I will sync data from sql to elastic. My config was running a few tries but now It is deleting my docs. Sync is successful and I dont see any error.

My config

```auto
input {
jdbc {
		jdbc_driver_library => "C:\Program Files\sqljdbc_10.2\enu\mssql-jdbc-10.2.1.jre17.jar"
		jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
		jdbc_connection_string => "jdbc:sqlserver://localhost:4433;database=mssql;iencrypt=true;trustServerCertificate=true;"
		jdbc_user => "sa"
		jdbc_password => "123_sa"
		jdbc_paging_enabled => true
		clean_run => true
		type => "call"
		plugin_timezone => "local"
		tracking_column => "last_modified_date"
		use_column_value => true
		tracking_column_type => "timestamp"
		schedule => "*/15 * * * *"
		statement => "SELECT TOP (10) * from call where last_modified_date > :sql_last_value ORDER BY last_modified_date ASC"
		last_run_metadata_path => "C:\Elk_Stack\logstash-8.3.3\last_modified_process"
	}
}

output {
elasticsearch {
		hosts => ["http://localhost:9200"]
		index => "call"
		user => "elastic"
		password => "xxxxxx"
		document_id => "%{[@metadata][_id]}"
	
		}
}

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/f/6fec93952049df51c39fb86a0b6a431fe423507c.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 13, 2022, 8:58am UTC](https://discuss.elastic.co/t/deleted-docs-sql-sync/312153/2 "2022-09-13T08:58:06Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.