We recently migrated a SQL 2000 database and an accompanying file share from a physical to a virtual machine.
All went well and the physical SQL database and file share were taken offline and the shares removed. No problems so far.
The problem came in that when they physical machine was shut down the client application using the database started to exhibit seizures although on each occasion it would evenutally come back with the right information.
The puzzle is that even with the SQL server service completely disabled on the physical machine the client has no issue, it is only when the server is shut down it somehow brings about a problem.
I realise this problem could have many causes and think that what is needed is a way of detecting what exactly is being accessed on the physical server and by what in order to track down the source of the problem.
Can anybody reccomend a tool I can run on the physical server so I can observe the nature of inbound communications which are being received?
Thanks in advance.