Moving a huge table to another server. RRS feed

  • Question

  • Hi,

        I am supposed to move a huge table from server1.DB1 to server2.DB2 having the storage info as below.

    Index Space         403,020.680 MB
    Row Count 11711690455                  
    Data Space        1,077,281.633 MB

    Please suggest me the most efficient and quickest way to move the table. We can afford a max downtime of 40 hrs.

     Best Regards,


    Kanhaiya Agrawal
    Wednesday, May 18, 2011 6:15 PM