SQL Server hangs on??

vbboyd · October 30th, 2013, 11:08 AM

When I try to deploy the .mdf file that sits under the SQL Sever 2012 environment off of my PC onto the production server at the web hosting service (or even locally on my PC) by using windows explorer or an FTP tool like FileZilla, I get a very peculiar error message that says something like: Unable to copy .MDF file because it is being used by another process or at least words to that effect. Any ideas of what might be going on here? Why is SQL server being so stubborn and not allowing the .mdf file to be copied so that it can be deployed? What needs to happen to change that?

Imar · October 30th, 2013, 11:11 AM

Sight. You really don't get it, do you. What does this have to do with my book? Where do I talk about FTP and copying databases? Pick a general forum for general questions or I'll stop answering your questions at all.

That said: SQL is not stubborn; it needs a lock on the file in order to work with it. Either release that lock by recycling the web site or SQL Server, or use other means to update the database.

Imar

vbboyd · October 30th, 2013, 11:35 AM

An a big chapter in your book? You go into great detail in your book on how to deploy to the production sever and that includes the Database part of it too. I thought that Deployment questions would be fair questions to answer in this forum.
I mean there can be error problems that come following the instructions in your book on deployment and I thought that could be answered here.

Imar · October 30th, 2013, 11:39 AM

Quote:

I thought that Deployment questions would be fair questions to answer in this forum.

They are, but not in this category. There is no reference to an exercise, you're having problems with steps not described in the book, you're using an update mechanism I am not describing etc etc etc. So, this is a general question for a general category here at p2p.wrox.com

I have explained it before but let me do this once more: this is not about you or me. This is not about me not wanting to answer your questions. I'll be happy to take a look at them if you post them in an appropriate location. This is, however, about future visitors to this forum category. They come here to read questions directly related to my book. For general questions, their search will be broader and will include the general forums as well.

Why don't you err on the safe side and always post in a general category?

Imar