Adding SQL Server Express files no workie

danthman · Post by **danthman** » Tue Dec 26, 2006 8:13 pm

Do I need to detach database files before adding them to a repository? I get the following error if I try to add MDF & LDF files without detaching first:

-----
The process cannot access the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\MyDatabase_log.ldf" because it is being used by another process.
-----

I find this a little confusing. If Vault doesn't need write access to these files (does it?), then why does it matter if they're being used by another process?

Thanks,

-Dan

lbauer · Post by **lbauer** » Wed Dec 27, 2006 9:27 am

If Vault doesn't need write access to these files (does it?), then why does it matter if they're being used by another process?

I'm not sure what Vault's doing at this point -- but if the file is open and in use, Vault can't access it. I reproduced the same thing with an open Word doc.

You could temporarily stop SQL Server if you don't want to detach the database files.

danthman · Post by **danthman** » Wed Dec 27, 2006 12:42 pm

"You could temporarily stop SQL Server if you don't want to detach the database files."

That would be easier. I didn't try that, though, because I was worried shutting the whole SQL Server down would cause problems with Vault since it uses the same server to store its own data. (I'm using the same machine for server and client.)

Is this not a concern?

Thanks,

-Dan

lbauer · Post by **lbauer** » Wed Dec 27, 2006 12:54 pm

That's true. You wouldn't be able to use Vault while SQL Server is stopped.

danthman · Post by **danthman** » Wed Dec 27, 2006 1:04 pm

Okay, so detaching it is, then. A little inconvenient but at least I know how to make it work. Thanks.