<div>
do you have a enterprise edition of sql2008. if yes they you can do an online restore.<br />
<br />
if you dont have a enterprise version then - first you have to kick all the users out and then do a restore. <br />
do a sp_who2 &nbsp;and kill the active connections to the db<br />
<br />

</div>


do you have a enterprise edition of sql2008. if yes they you can do an online restore.

if you dont have a enterprise version then - first you have to kick all the users out and then do a restore.
do a sp_who2  and kill the active connections to the db



<div>
Hi,<br />
&nbsp; How do I know what are active connections after running sp_who2? What is the command to kill active connections?<br />
<br />
Thanks.
</div>


Hi,
  How do I know what are active connections after running sp_who2? What is the command to kill active connections?

Thanks.

<div>
&gt;&gt;How do I know what are active connections after running sp_who2?&lt;&lt;<br />
You identify all the spids that have the dbname you are attempting to restore.<br />
&gt;&gt;What is the command to kill active connections?&lt;&lt;<br />
That would be KILL<br />
<br />

</div>


>>How do I know what are active connections after running sp_who2?<<
You identify all the spids that have the dbname you are attempting to restore.
>>What is the command to kill active connections?<<
That would be KILL



<div>
find the connections to your DBname when you run sp_who2<br />
find the corresponding spid<br />
<br />
to kill ... exec<br />
<br />
KILL spid_here <br />
<br />
or you can just ask the users to log off while you restore. 
</div>


find the connections to your DBname when you run sp_who2
find the corresponding spid

to kill ... exec

KILL spid_here

or you can just ask the users to log off while you restore.

<div>
Hi, <br />
&nbsp; &nbsp;Do I kill &nbsp;process in 'sleeping' status for my DBname.<br />
<br />
Thanks.
</div>


Hi,
   Do I kill  process in 'sleeping' status for my DBname.

Thanks.

<div>
yes... as they hold a connection to ur db<br />

</div>


yes... as they hold a connection to ur db


<div>
Hi,<br />
&nbsp; So no matter what the status is kill all connections to my DB. Is that right?<br />
<br />
Thanks.
</div>


Hi,
  So no matter what the status is kill all connections to my DB. Is that right?

Thanks.

<div>
<div class="content wysiwyg-content">
Hi, <br />
&nbsp; How to do a restore of sqlserver 2008 database if multi user are logged in. <br />
<br />
Thanks a lot.
</div>
</div>


Hi, 
  How to do a restore of sqlserver 2008 database if multi user are logged in. 

Thanks a lot.

Sqlserver 2008 restore

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.