Post reply

New Box for production

  • October 18, 2005 at 7:11 am

    #110668

    HI, I just need some information regarding SQL adminitration.

    We are having Prodcution Database and Development Database on the same machine,We are also having all the Backups(prod & dev) also on the same single machine. But now I want to request for a new box so that I can have prodcution and Development on different box. Please input your ideas on this and what are the considerations I have to look for, to do this job.

  • October 19, 2005 at 3:27 pm

    #598499

    I am going to, ughhh, assume, that your present server is sized correclty and performing well. In an ideal world your devlelopment server would mirror your production server (cost and politics aside). You may want to consider adding a test/prod-fix instance to your 'new' development server. One thing I would definitely do is use the new server for production. The advantages of this are:

    • you can build it correctly (if there are any issues you have at present)
    • you'll have the advantage of newer equipment (usually)
    • you can create/test/document/execute a both a partial and a complete DR scenario (take the opportunity NOW !)

    That's all I can offer based on the limited information in the post.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply