Backing Up for my Primary/Secondary Environments

8

September 8, 2009 by Mike Hillwig

Every environment is different, and that means everyone does backups differently. I thought I’d talk about how I do it in my environment.

For most of our key business applications, we have two sets of servers, a primary and secondary. The secondary servers are in a different data center. Fortunately, bandwidth isn’t a problem.

I need to keep my secondary servers current in case the primary data center becomes unavailable. This is the perfect place to implement log shipping or database mirroring. Unfortunately, we also use the secondary servers for testing. That means we do it the old fashioned way, backup the primary and restore to the secondary. I’m not saying it’s right, but it’s the environment I have.

I’m a complete nut for consistency. When I inherited this environment, we had network shares and copy scripts for database backups. No two applications did their backups the same way. One day, I ripped it apart and put it back together. Since all of my database servers use the same domain service account and that service account has administrative rights on all database servers, security isn’t a problem. It also means I can write to the administrative shares on other servers without the need to create shares or users.

First, I wrote a single script that gets used across every primary server. With a few parameter changes, my script works for every system. Basically, I build a list of databases and then back them up to the file system on the local file server. That’s the one that gets sent to long-term storage. Next, I write the backup file to the secondary server.

My script is on my site. I’m really proud of this and it has served us well. As you’ll see in the comments, this works well in our small environment with lots of small databases.  This won’t scale well after we double our current size.

Of course, I still back up my transaction logs. I would love to hear some feedback from other DBAs who can help me make this better.

My next step is to write a consistent recovery process.

8 thoughts on “Backing Up for my Primary/Secondary Environments

  1. Gunjan says:

    My wife and i felt really glad that Edward could carry out his inasteigvtion from the ideas he came across through the site. It’s not at all simplistic just to happen to be making a gift of things that many some others have been making money from. And we all keep in mind we need the blog owner to give thanks to for this. The main explanations you have made, the straightforward web site menu, the relationships you can aid to engender it’s got mostly exceptional, and it is making our son in addition to the family believe that that theme is entertaining, which is certainly quite pressing. Thank you for the whole lot!

  2. Eu acho que ao ivés de dar o peixe tem que dar o anzol.Em alter tem muitas aréas desocupadas que pode ser utilizada para plantio,mais ninguem quer meter a mão na terra,só querem as coisas na mão,prefeita,secretaria,inovem um programa de produção.Certo que muitos precisam,mais tem muita gente vagabunda mamando na teta

  3. que traen en contra del español mexicano?!para la colombiana frustrada que ha dicho “donde la mayoría de los mexicanos han introducido su pésimo español (campero cantado) y para componer le han agregado spanglish” he de decir, que si le molesta tanto como hablan el idioma en el país en el que está, remedie y se regreses a su lugar de origen, el español de México es muy rico, hay de todo, y cada estado tiene un estilo, ok, hablamos cantadito a veces, pero si se escucharan aqui, como lo hacemos nosotros… eso de “comerse” las s al hablar… ja!me he dado la ofendida de mi vida

  4. Det høres herlig ut Kjersti! Kos deg med alenehelg! Vi er endelig i hus og det er deilig, flere bilder kommer nok:)Ikke lenge igjen til før dere blir fire nÃ¥ vel – spennende! God kveld, venter pÃ¥ korslaget jeg nÃ¥!klem Ellen

  5. I would like to thnkx for the efforts you have put in writing this site. I am hoping the same high-grade web site post from you in the future also. Actually your creative writing skills has encouraged me to get my own web site going now. Really blogging is spreading its wings and growing rapidly. Your write up is a great example.

  6. This is the proper PS Vita gets second firmware update, nixes software bugs | My Blog journal for anyone who wants to act out out about this matter. You observance so untold its nigh wearying to discourse with you (not that I real would want…HaHa). You definitely put a new rotation on a subject thats been codified some for eld. Fastidious squeeze, just majuscule!

  7. Allison, I believe you can although the amount would be less and the texture might be different. I haven’t done too much exploring with coconut flour because the results haven’t been the best, but I would be interested in knowing!

  8. hola soy rommel vivo en ecuador y desde un par de meses estoy en buenos aires por motivos de estudios estare aqui dos años asi que desesperado por encontrar alguien que me guie como cocinar algo de mi tierra encontre este sitio que me parece divino, vi la foto del arroz con menestra y casi me el monitor espero que me salga igual que en la receta y sigan poniendo mas platos tipicos de mi lindo ecuador

Leave a Reply

Your email address will not be published. Required fields are marked *