August 26, 2005 at 7:25 am
I want to restore over a database which I do not know how may people are using. I cannot stop my server.
There Two solutions
1) If I come two know exactly who are currenty connected with database. Then I may ask to close the connection
2) If I am able to restore it without asking anybody to disconnect and they get disconnected automatically.
I want to restore database any how.
August 26, 2005 at 7:31 am
Hi,
1) If I come two know exactly who are currenty connected with database. Then I may ask to close the connection
You may run sp_who which return you a list of users who are using the database.
2) If I am able to restore it without asking anybody to disconnect and they get disconnected automatically.
You may kill all the users after you get the list of spids from sp_who and then put the database i single_user mode and restore it.
--Kishore
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply