how would you restore data ? replace exiting objects, or load back level zero data ?
if replace stop application and if u have level zero backup
usually it happen if any user is logged in to cube > check sessions
There are certain db tools which will take your application back in time , by replacing the entire application !! I did check the session ets etc . All was clean yet I see "File in Use"