SQL Server Performance Forum – Threads Archive

Log Shipping From Enterprise to Standard

We are in the (very) fortunate position of having an Enterprise cluster for our main database. We have a requirement to ship logs from this server to a standard server in another location. It is not going to be a secondary server to the cluster. It is for performing archiving/backups and querying against due to WAN link restrictions at the cluster’s location. Can we use Enterprise’s log shipping feature to perform this? Would we have to do manual restores on the Standard server or use manual log shipping on both? The data has to be current on the Standard server. Thanks in advance for any help.

Standard edition doesn’t have the support of log shipping, so you may not be able to seteup.
http://www.sqlmag.com/Article/ArticleID/23231/sql_server_23231.html
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>