LiteSpeed LogShipping - the "Publisher" is SQL 2005, the "Subscriber" is SQL 2008.
How to configure the Stand-by server so that the log-shipped DB is in "Stand-by" mode rather than "Recovering" mode. While configuring logshipping in LiteSpeed, I got the "error" that since the source is 2005 and destination is 2008, conversion is necessary, thus, "stand-by" mode is not available.
Native SQL behaviour
This is a limitation of Microsoft's SQL Server. When you restore SQL Server 2005 t-logs to SQL Server 2008, you can’t use STANDBY mode because the database goes through an upgrade.
