locked
how to Migrate 1 TB databse with 30 Mins Down Time? is it possible ? RRS feed

  • Question

  • How to Migrate 1 TB database (30 Mins down Time) is it possible ?
    Friday, November 1, 2013 8:27 AM

Answers

  • How to Migrate 1 TB database (30 Mins down Time) is it possible ?

    Other method is backup and restore.
    1. take backup of database and restore it on destination with no recovery
    2. take trn log backup and restore it on destination with recovery
    3. Migrate logins and jobs using script method
    4  Migrate packages
     In all these times  you have not made source DB  offline.

    There can be some data lag between source and destination in this case


     Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers



    Friday, November 1, 2013 10:51 AM

All replies