Post reply

Moving a VLDB

  • May 16, 2012 at 12:59 am

    #260836

    Hi,

    I am hoping someone can assit me here. I have a system that is hosted by a 3rd party. We are looking to bring it in house. Now the database is backed up nightly with hourly tlogs taken. It is hosted some 5000km away so to copy the back up usually takes a day. Now what I want to do is get a copy of a backup restore it then apply the logs on going for say a few days, then at thelast minute we have an outage. Back up the log and tail and restore them to the new system then set the old one to read on and point all the users to the new on....

    What are your thoughts around this....

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • May 16, 2012 at 2:17 am

    #1488231

    What you are suggesting sounds feasible, I have done similar in the past. You may want to consider differential backups ad well to reduce the number of logs you need to apply, but the technique sounds good.

    Mike

  • May 16, 2012 at 3:04 pm

    #1488699

    You could also consider database mirroring. Setup the mirroring and when you are ready - failover to the partner, redirect your users and tear down the mirroring.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • May 16, 2012 at 4:37 pm

    #1488731

    I think the method is sound.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 16, 2012 at 6:02 pm

    #1488750

    Thanks for the positive reposnces. The relationship with the 3rd party vendor is deteriorating which is why we are looking ot move the system in house. If it was a good relationship I would trust them enough to let them know the plans and then involve them ie set up mirroring or alter the backup to include diffs but this is all happening under the covers .... which is just crazy as it is our system but they also host one or two others and dont want them to do anything untoward.....

    So it looks like I will be planning a "DR" test back to our site..as they dont offer DR rather recoverability via VM's.

    Thanks all for you assistance.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

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

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