<div>
vineethvp: How do I find the process ID for this? &nbsp;I ran a script to show currently running jobs and have the GUID for the job, but not the process ID. Can I use the GUID?
</div>


vineethvp: How do I find the process ID for this?  I ran a script to show currently running jobs and have the GUID for the job, but not the process ID. Can I use the GUID?

<div>
Try this to find the PID<br />
<br />
<a href="https://www.experts-exchange.com/questions/23501488/SQL-query-to-get-Process-ID.html" rel="ugc">https://www.experts-exchange.com/questions/23501488/SQL-query-to-get-Process-ID.html</a>
</div>


Try this to find the PID

https://www.experts-exchange.com/questions/23501488/SQL-query-to-get-Process-ID.html [https://www.experts-exchange.com/questions/23501488/SQL-query-to-get-Process-ID.html]

<div>
<div class="content wysiwyg-content">
I started a restore database process in SQL Server 2005. &nbsp;It sat for quite a while executing but never got past 0%. So, I cancelled the restore in the Restore window, which worked, and the window closed. &nbsp;Now this database shows &quot;(restoring...)' out to the right of the database name in SQL Manager.<br />
<br />
What is the SQL script I need to execute to get this database out of 'restoring' mode so that I can try the restore again?
</div>
</div>


I started a restore database process in SQL Server 2005.  It sat for quite a while executing but never got past 0%. So, I cancelled the restore in the Restore window, which worked, and the window closed.  Now this database shows "(restoring...)' out to the right of the database name in SQL Manager.

What is the SQL script I need to execute to get this database out of 'restoring' mode so that I can try the restore again?

How to stop SQL Server 2005 restore in progress

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.