<div>
You should be able to perform in-place upgrade and keep your log shipping intact. Sequence-wise - upgrade you stand-by server (Server B) first. <br />
<br />
Don't forget to update statistics (sp_updatestats) after the upgrade.
</div>


You should be able to perform in-place upgrade and keep your log shipping intact. Sequence-wise - upgrade you stand-by server (Server B) first.

Don't forget to update statistics (sp_updatestats) after the upgrade.

<div>
Thanks <br />
<br />
My database on the the remote machine is in Stand-by/read only mode. Can I still do the in-place upgrade
</div>


Thanks

My database on the the remote machine is in Stand-by/read only mode. Can I still do the in-place upgrade

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
&nbsp; I am planning to upgrade my SQLserver 2005 x64 (standard) &nbsp;to SQLServer 2008 . &nbsp;Can I perform the upgrade without having &nbsp;to redo my log shipping.<br />
<br />
currently , I have 2 servers (Windows server 2008 R2 64bit)<br />
<br />
Server A is primary and Server B contain my database in Stand-by mode<br />
<br />
Is there a sequence that I should follow to do the upgrade.<br />
<br />
Thanks for your help
</div>
</div>


Hello,

  I am planning to upgrade my SQLserver 2005 x64 (standard)  to SQLServer 2008 .  Can I perform the upgrade without having  to redo my log shipping.

currently , I have 2 servers (Windows server 2008 R2 64bit)

Server A is primary and Server B contain my database in Stand-by mode

Is there a sequence that I should follow to do the upgrade.

Thanks for your help

Upgrade SQLServer from 2005 to 2008 (primary and standby )

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.

Microsoft SQL Server 2005

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.