October 25, 2002 at 10:26 am
Hi All,
This is a resurrection of an old friend (DR). I have come to a new shop for a short 8 week assignment, and have found a birds nest to deal with. The company's DBA is not a SQL Server DBA, but a good oracle one, is away on holiday. I've been asked to first cover for any new issues, second look into and immediately fix any sleeping giants, and third provide some long term planning and suggestions. I'll be lucky if I could fix 1/3 of the second request. There are over 14 servers, one alone has 45 databases on it, we can only try.
My hardware environment:
Box A - SS7.0/sp3 dedicated for a prod web DB. This is a 4*550 P3 Xeon, 2Gig RAM with 3 18 gig drives in 1 RAID 5 array, no hot spare, effect capacity of 36 gig. No additional room for drives. The drive config on production is a nightmare that I can't address now. There are 41 user dbs totaling 12 gig in size, a ton of complex DTS packages with all sorts of business link, transformations, flat file generations going on, Plus all the jobs to go along with running them.
Box B - No SS7 yet, it's a 4*450 P2 Xeon, 2gig RAM, 4 9 gig drives at capacity.
No budget for more hardware at this time (that familiar ring).
Bottom line they can't afford to lose transactions - I want to use Box B has a hot standby server. I'm thinking log shipping, but I've never done one for 45 databases and what about all those DTS packages? There's good bit of code change due to bus needs, that goes into the DTS packages so a one time back does it quiet work. Any thoughts on getting my around this baby?
Best regards,
John Zacharkan
John Zacharkan
John Zacharkan
October 25, 2002 at 11:29 am
Log shipping should work, its not going to be that much extra work compared to just doing the log backups anyway. Simpler and fewer constraints than trying to use replication. On the package part - maybe just a job that does the sync once a day? Are all 45 db's of the same importance? Might consider replicating the super critical ones AND doing log shipping (to a separate copy).
Andy
October 25, 2002 at 12:27 pm
Nice to hear from you Andy.
Is there script for copying over the DTS packages and jobs? I usually just open a package and save it to another server. If there a script already written that unloads and loads the packages. I'd probably run that daily.
As far as database importance, I'm still trying to determine that. Most of the databases are related - used with admin tools for a web store that is composed of various business units all brought together. The design leaves a bit to be desired.
Zach
John Zacharkan
John Zacharkan
October 25, 2002 at 1:17 pm
I think I found my answer, Copying DTS Packages To a Different Server Posted: 03/19/2002 by you Andy
I'll give it a shot, hope it works in 7.
Zach
John Zacharkan
John Zacharkan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply