November 26, 2008 at 10:48 am
Hi all!
We have opened a plant in Thailand and I need to sync a very small database that we have here in California. My boss doesn't want spend the license for Enterprise edition in Thailand for 1 50MB database so I was wondering if anyone knows a good way to utilize log shipping with SQL Express edition. I have a job that is doing a log backup of my primary db to a network folder and my problem is that SQL express does not come with an Agent to schedule the restore on the server in Thailand. I downloaded an application called Scheduler 2.0 but it's not very robust and doesn't have many options. I have the script that copies the log from the network folder and does a restore with standby option to the database in Thailand, I'm just trying to find out the best way to schedule it? I haven't had great success with Windows scheduler in the past. Anyone use Powershell? Can it be done with that?
Thanks in advance and have a great Thanksgiving!!
Isabelle
BTW...SQL PASS summit 2008 rocked!! 😀
Thanks!
Bea Isabelle
December 1, 2008 at 5:14 am
Good news. You don't need the Enterprise edition (2k5) to get logshipping (and mirroring). Just get SQL2005 Standard Ed. Logshipping is then a few mouse clicks away. Sadly SQL Express doesn't have these functions. You might, might be able to rig something up with a scheduled type task (Windows or 3rd party) but personally I wouldn't. Too much of a headache and every tiny hiccup would mean lots of work trying to get it restarted.
Put forward a business case to your boss of the cost of SQL2005 Standard vs the doom of not having a warm (logshipped) standby.
December 1, 2008 at 6:56 am
Have you considered replication? Express can be a subscriber and based on what you are saying you don't need to be able to write to the Express database.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 1, 2008 at 9:32 am
Hi,
Yes, I considered replication but was under the impression that it requires a seperate license so that's why I was thinking about log shipping. I already have it setup here for my production system and it works great. I didn't know about standard edition! I will make my case to my boss and hope that he will go for that.
Thanks!
Isabelle
Thanks!
Bea Isabelle
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply