I have a SQL Server Job set up to import data from a table to a table on another server, using the Import/Export data wizard.
In one instance, the job failed (with, I believe a SQL connection issue), and with that, the data from both tables were deleted. The tables on both the source and destination server were removed.
Does this make sense? If anything, why would the data be removed from the source?
The source is SQL Server 2012 and the destination is SQL Server 2008.