SQL 2008 SP1 - Log shipping solution with Logshipping monitor on SQL Server Express Edition SP1 (bad version)

Question

Hello All !

I'm installing a log shipping solution with SQL Server 2008 Standard SP1 (on x64 US). I use a monitor logshipping with SQL Server Express Edition x64 SP1 US. When I try to connect it, I have this message when i tried to use w.x.y.z\SQLEXPRESS  as a monitor server:

'w.x.y.z\SQLEXPRESS' is not a valid monitor server instance.  A monitor server instance must be SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition.'

In SQL 2005, it is possible to do that with SQL Express. And with 2008 R2, is it possible too or it is the same problem ?

---

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

Answer 1

http://msdn.microsoft.com/en-us/library/ms188698.aspx

Requirements

---

Log shipping has the following requirements:

• For information about which editions of SQL Server support log shipping, see Features Supported by the Editions of SQL Server 2008 R2.  

• The servers involved in log shipping should have the same case-sensitivity settings.

• The databases in a log shipping configuration must use the full recovery model or bulk-logged recovery model.

 

http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.100).aspx

Express doesnt support LS .. you might want to upgrade to DBM.

Answer 2

Hello !

Thanks for these links.

 

 

---

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2