One of my clients uses a VFP9 app with MSSQL SERVER databases
Two databases
database A stored in the hard disk (C:)
databaseB (with confidential data) stored in an external hard disk (E:)
The Sql Server Management Studio correctly shows, in each database properties windows, in the files option, that the A database resides in disk C and the B database resides in disk E
However, if I physically remove the hard disk (E:), the management studio still shows all tables of database B and select statements show data from the applicable tables.
I thought that the data resides in memory in the cache. So I disconnected the SSMS from the engine, even turned off the SSMS. Then, when the SSMS was up again, it would still show the database B (even if its lodging HD was disconnected and put away in a drawer) and queries would still show data from any of the tables.
What is going on?
How can I prevent this "ghost" behaviour?
It is very important that, when the external hard disk is removed, no confidential data can be read at all.
Rafael Copquin
--- Este correo electrónico ha sido comprobado en busca de virus por AVG. http://www.avg.com