<div>
<div class="content wysiwyg-content">
Our weekly backup failed because some joker was working at 3am Sunday morning and had a connection open to the DB! We have a BATch file which ...<br />
<br />
isql -S MyOldSvrName -E -U MyLoginID -P MyPswd -Q &quot;sp_detach_db 'MyDB', 'true'&quot;<br />
del \\MySvr\backup\MyDB_Data.M<wbr />DF<br />
del \\MySvr\backup\MyDB_Log.LD<wbr />F<br />
copy \\MySvr\MyDB_Data.MDF \\MySvr\backup\MyDB_Data.M<wbr />DF<br />
copy \\MySvr\MyDB_Log.LDF \\MySvr\backup\MyDB_Log.LD<wbr />F<br />
isql -S MySvr -E -U MyLoginID -P MyPswd -Q &quot;sp_attach_db @dbname = 'MyDB', @filename1 = 'C:\MyDB_Data.MDF', @filename2 = 'C:\MyDB_Log.LDF'&quot;<br />
<br />
To run sp_detach_db ALL CONNECTIONS MUST BE TERMINATED!<br />
How to force-terminate all connections using a stored proc?<br />
<br />
Any ideas?<br />

</div>
</div>


Our weekly backup failed because some joker was working at 3am Sunday morning and had a connection open to the DB! We have a BATch file which ...

isql -S MyOldSvrName -E -U MyLoginID -P MyPswd -Q "sp_detach_db 'MyDB', 'true'"
del \\MySvr\backup\MyDB_Data.MDF
del \\MySvr\backup\MyDB_Log.LDF
copy \\MySvr\MyDB_Data.MDF \\MySvr\backup\MyDB_Data.MDF
copy \\MySvr\MyDB_Log.LDF \\MySvr\backup\MyDB_Log.LDF
isql -S MySvr -E -U MyLoginID -P MyPswd -Q "sp_attach_db @dbname = 'MyDB', @filename1 = 'C:\MyDB_Data.MDF', @filename2 = 'C:\MyDB_Log.LDF'"

To run sp_detach_db ALL CONNECTIONS MUST BE TERMINATED!
How to force-terminate all connections using a stored proc?

Any ideas?


URGENT: force ALL DB connections to terminate!

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.