Can we set up logshipping in sql server 2000 express edition

Question

Hi,

Can we set up logshipping in sql server 2000 express edition.

Thanks

Answer 1

Yes. You can. please refer this article http://msdn.microsoft.com/en-us/library/aa496029(v=sql.80).aspx

This article explains it better http://sqlserverpedia.com/wiki/Log_Shipping_Overview_(SQL_Server_2000)

 read the second link for better understanding.

---

Hope it Helps!!

Answer 2

yes you can setup,see below for 2000-

Log shipping in SQL Server 2000 provides a means of establishing a warm back up solution by using the SQL Server Maintenance Plan Wizard. Transaction log backups from a database can be automatically shipped to a different server and applied to a standby database. You can use the standby database to perform read-only operations (depending on the load state).

Log shipping in SQL Server 2000 provides a means of establishing a warm back up solution by using the SQL Server Maintenance Plan Wizard. Transaction log backups from a database can be automatically shipped to a different server and applied to a standby database. You can use the standby database to perform read-only operations (depending on the load state).

Log shipping set up

Q1: What edition of SQL Server do I have to have to set up log shipping?

A1: The following matrix shows the edition of SQL Server that is required for the three components that participate in log shipping:

Component	Edition of SQL Server required
Primary Server	Enterprise or Developer Edition
Secondary Server	Enterprise or Developer Edition
Monitor Server	Any Edition

Reference ->Frequently asked questions - SQL Server 2000 - Log shipping ->http://support.microsoft.com/kb/314515

I think for SQL server 2000 support is going to end or might be it end. so plan incase if you needed it.

---

Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Answer 3

Thanks for response.

what about the sql server 2000 express edition..Can we configure logshipping in express edition.

Thanks

Answer 4

I never used it, since the express eiditon donot have the agent in it where the logshipping works based on the agent control so no its not support,

the support is as mentioned below-

Q1: What edition of SQL Server do I have to have to set up log shipping?

A1: The following matrix shows the edition of SQL Server that is required for the three components that participate in log shipping:

Component	Edition of SQL Server required
Primary Server	Enterprise or Developer Edition
Secondary Server	Enterprise or Developer Edition

---

Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Answer 5

Thanks for response.

what about the sql server 2000 express edition..Can we configure logshipping in express edition.

Thanks

I think one work around would be to create backup/copy/restore job using windows task scheduler. If you look into the log shipping, this is what it is doing but uses sql server agent to do this. you will have to write scripts for  1.backup the database  2. Copy the files and 3.restore to secondary server. then using task scheduler, you let these scripts running as you want .This will not be as efficient as regular log shipping but can provide something similar. 

---

Hope it Helps!!

Answer 6

...but do not forget about the limitations of SQLExpress edition on database size & configuration, manually you can setup the log shipping and not all of the log shipping features can be performed with such editions.

---

Satya SKJ, Moderator - SQL Server MVP [Knowledge Sharing Network - www.sqlserver-qa.net]
Author of SQL Server 2008 R2 Administration cookbook.
Follow me @sqlmaster.