Do I need to stop the Database befor detach and attach database?

[dk2006]

I try to make two databases synchronize in both production and development servers. I am using detach and attach method. Do I need to stop database in SQL Server Service Manager first? I keep getting 'currently in use' error.

Thanks,
dk

 

[gmmastros]

The currently in use message occurs when someone else is connected to the database.

In QA, you can use sp_who and/or sp_who2 to see who is connected to the database.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[dk2006]

George,
This is a very fast response. Thanks. So I don't need to stop the service?

dk

 

[dk2006]

Never mind. I figured it out.

Thank,
dk

 

[gmmastros]

Ordinarily, you don't want to just stop the service just to detach a database. You can, but you have to realize that it will stop ALL the databases attached to that server.

By using sp_who, you can see the process9es) that are connected to the database you want to detach by looking at the DBName column.

You can even stop the process by using the kill command. Do NOT kill any processes with a SPID < 50. Those are reserved for SQL Server.

Just find the SPID and enter into QA...
Kill 55
This will kill the process with a SPID of 55 (55 being an example).



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom