I think this has to be serverside. Some way to check if there's any processes using the dabasefile.

But thanks for the ideas!

Edit
Ok, here's exactly what I want to accomplish...

• Backup a database that could be in use (ie, check this first)
  
• The db could be in use via clients on the network, or on the server (on both sides there's an application that locks the db, and has to be closed).
  
• Backup should be twice a week (monday & thursday), switching between two tapesets
  
• "Clients" managing the tapeswitching won't have access to the server.
  
• Some sort of notification system when they should change tapes (probably BLAT).
  

As u can see, i've got some scriptning to do.. It seems I can solve all the backup related things via ntbackup.exe on the 2000 servers, but then I have no control over the applications being open etc...

[ 14 December 2001: Message edited by: masken ]