Backup (Standby) Server

[istblj]

I'm trying to setup a Standby SQL Server to mirror my Production SQL Server and am using a command &quot;Load Database&quot; which fails every time with the following error:<br><br>[Database in use. System Administrator must have exclusive use of database to run load. (Message 3101)]<br><br>I did a sp_who and killed whatever spid showed up, but still I get the same error.&nbsp;&nbsp;Could it be because users are accessing the Production Server in which I am trying to run the Load from?&nbsp;&nbsp;This is what the command line looks like:<br>A: Production Server:&nbsp;&nbsp;<br>DUMP DATABASE DOCS TO DOCSData1 WITH&nbsp;&nbsp;NOUNLOAD ,&nbsp;&nbsp;STATS = 10,&nbsp;&nbsp;INIT ,&nbsp;&nbsp;NOSKIP<br><br>B: Backup (Standby) Server:<br>use docs<br>go<br>sp_dboption docs, &quot;dbo use only&quot;, true<br>go<br>load database docs from docsdata1<br>go<br>sp_dboption docs, &quot;dbo use only&quot;, false<br>go<br><br>Any assistance you can provide would be very much appreciated.....I'm in a desperate state!<br>Thanks.

 

[calahans]

I have got this before - I went in to enterpriose manager and killed EVERY process bar my own (even the system lazy writer one). This then allowed me to restore. <p>Cal<br><a href=mailto: > </a><br><a href= > </a><br>