Post reply

Environment Mirror

  • January 5, 2011 at 11:59 am

    #231829

    Hi Guys!

    I have a question and I need some advices.

    I have in my company one SQL Server 2005 with cluster that is the production, and a I have too another SQL Server 2005 no clustered, that is a server approval and development and it has some databases of the production.

    But to keep updated I need make the backup and restore everytime. So I would like keep this server updated with day - 1, and I researched some features, SSIS, Mirror or Replication. But I couldn't identify what is the better. I need help.

    Thanks !

    []'s
    Douglas R. Oliveira

  • January 5, 2011 at 1:10 pm

    #1269731

    It depends on the environment and the limitations.

    Both Log Shipping and Mirroring can be used for the database level synchronization.

    But in General, I'd prefer Mirroring.

    Thank You,

    Best Regards,

    SQLBuddy

  • January 5, 2011 at 3:04 pm

    #1269780

    If you want those databases to be updateable why not just automate the overnight restore, or perhaps use snapshot replication.

    If the databases only need to be readable then you could use logshipping but only restore the logs overnight, or use mirroring with database snapshots if you have enterprise edition.

    Personally I would go for the simpler methods based on backups and restores.

    ---------------------------------------------------------------------

  • January 7, 2011 at 4:23 am

    #1270553

    Thanks Guys, for your replies!

    I'll try to make with a replication, if I succeed, post here again

    []'s
    Douglas R. Oliveira

Viewing 4 posts - 1 through 3 (of 3 total)

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