Can't copy sql database, because it says file is already open, when it isnt?

Question

4.50/5 (2 votes)

See more:

So i'm trying to copy a database I made in sql, but when I try to it doesnt allow me, it keeps saying that the file is already in use, when it isnt. Anyone know how I check to make sure its running?

Posted 8-May-11 7:16am

programmer1234

Updated 24-Feb-21 23:47pm

Add a Solution

2 solutions

Solution 2

Are you absolutely sure that nothing is currently connected to your database? I had this problem but it turned out that a Windows Service was using it unbeknownst to me.

Use this query for a list of connections to databases

SELECT DB_NAME(dbid) as database_name, nt_domain, nt_username, hostprocess
FROM sys.sysprocesses
WHERE dbid > 0

The hostprocess field is the Windows Process ID which you can then look up in the Task Manager.

Posted 24-Feb-21 23:47pm

Colm de

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

IncredibleRam · Accepted Answer · 2011-05-08T07:56:00

As you want to copy a Database so you know where to find it and name and type of the server.
ok to do that first of all you have to detach the database from the SQL server
there are two ways to do that
1. Open the Managament studio for SQL and then connect to the specified Server.open the database node and right click on the database choose Task->Detach. now you can copy the database.but after this you have again attach to the database.
2. go to Start Menu -> SQL Server -> Configuration Tools ->SQL Server Configuration Manager. This will open a new window for you. right click on SQLSERVER(SQLEXPRESS or the Name Of The Server) And Select Stop. New You can copy the Database. After Copying Again Right Click On The SQLSERVER(Name Of The Server) And Start The Service.
if this will not help you with the problem let me know.
Best Regards.