Daca este auto-close da.

MSDN:

When set to ON, the database is shut down cleanly and its resources are freed after the last user exits. The database automatically reopens when a user tries to use the database again.

Acel 'resources are freed' inseamna si ca handle de fisier sint inchise si fisierele numai sint blocate pentru copy/delete etc.
In mod implicit SQL EXPRESS le creaza auto-close ON. Potzi verifica cu sys.databases.is_auto_close_on.

---

http://rusanu.com