how to backup and restore a single table from server 2 server

  • Hi

    sql 2005

    I have to take a Backup of a table from prod instance and restore the same in Reporting instance.

    this process should be automated, kindly tell me the beset way of doing .

    Note:- SSIS is not recommended in our organization, please dont suggest that. Suggest me some best solution.

    Thank you

    Hemadribabu

  • duplicate post.

    replies here please http://www.sqlservercentral.com/Forums/Topic1019725-146-1.aspx

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

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

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