log shipping on SQL Server Express

Category: sql server distributed


Lanhale on Mon, 07 Dec 2015 06:30:20

I am using SQL Server Express but can getting the log shipping options .How can I get it ?


Ahsan Kabir on Mon, 07 Dec 2015 06:31:30

SQL Server Express Edition is not Possible For Implementing Log Shipping because SQL Server Agent Services are not available.

Lanhale on Mon, 07 Dec 2015 06:36:26

Which version required ?

AbsolutelyFreeWeb on Mon, 07 Dec 2015 06:36:32

You can use log shipping with web, standard, BI and Enterprise editions, but not express, express with tools or express with advanced services

Lanhale on Mon, 07 Dec 2015 06:38:21


Shanky_621 on Mon, 07 Dec 2015 09:21:53

You can actually configure * A type of Logshipping* not excatly log shipping. You can create a job to backup transaction log , then use windows scheduler to move the backup file and then again use scheduler to restore it. but from your question I can gauge you are a beginner so yes gof or Stand, ent for logshipping