unlock database files when SQL server is idle

Posted by Andy on Server Fault See other posts from Server Fault or by Andy
Published on 2013-10-19T11:45:24Z Indexed on 2013/10/19 15:58 UTC
Read the original article Hit count: 186

Filed under:

In my development/test environment on my laptop, I can't back up the SQL server database files because the file handles are kept permanently open by SQL server (VSS doesn't work because the drive is truecrypted)

I was hoping there may be some setting in SQL server that can make it unlock the data files after a certain period of inactivity and automatically open them again on demand, but I can't find anything.

I don't really want to be dumping the database out every night because it's only a development environment. apart from stopping sql server before I do the backup is there any other solution?

© Server Fault or respective owner

Related posts about sql-server