I have desktop application using SQL Server LocalDB as database. Application is installed on desktop and Database is on Pen Drive.
I am accessing Database from application as :
data source=(LocalDB)\v11.0;attachdbfilename=H:\Database\CompetitorDB.mdf;
(H: is Removable Disk / Pen Drive)
My Question is :
1> Does Accessing Database in this way creates any local copy of Database on the desktop?
2> Does Accessed data through Application get stored in any form on the on the desktop.
3> If so then How can I avoid data traces?
Since I do not want any sensitive data/traces to be on desktop once I remove the pen drive in order maintain the security of information.