<div>
The stand by mode put your database in a read-only mode, storing all the uncommited transactions in your stand by file... if you want to make it active, you can take your last log backup and restore it using WITH RECOVERY<br />
<br />
This is commonly used in log shipping
</div>


The stand by mode put your database in a read-only mode, storing all the uncommited transactions in your stand by file... if you want to make it active, you can take your last log backup and restore it using WITH RECOVERY

This is commonly used in log shipping

<div>
Is there a T-SQL command to make it active WITH RECOVERY option<br />
<br />
Thanks
</div>


Is there a T-SQL command to make it active WITH RECOVERY option

Thanks

<div>
Thanks got the quick reponse
</div>


<div>
<div class="content wysiwyg-content">
In sql server 2005 what is the significance of the database in standby mode and how to make it active
</div>
</div>


In sql server 2005 what is the significance of the database in standby mode and how to make it active

standby sql server 2005 significance and restore to active

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.