SQL Server Performance

Need a query for table back up

Discussion in 'Getting Started' started by p_sunil26, Dec 30, 2010.

  1. p_sunil26 New Member

    Hi,I am newbie to SQL Sever and I need a query where I have to take back up of my existing table named "MemberInfo".Please suggest a query.Thanks in advance for your help!!Thanks
    p_sunil26, Dec 30, 2010
    #2

  2. jdgonzalez New Member

    select *into MyNewTablefrom MemberInfo
    jdgonzalez, Dec 30, 2010
    #3

  3. Luis Martin Moderator

    Welcome to the forums!.
    Where do you want to backup that table?
    Luis Martin, Dec 30, 2010
    #4

  4. satya Moderator

    Welcome to the forums.
    There is no provision available to backup a table seperately to a file, only by uisng SSIS package you can export the data to another data source and same package can be scheduled on SQLagent to run as per the schedule.
    satya, Jan 4, 2011
    #5

  5. Madhivanan Moderator

    1 Generate script for that table
    2 Export data to text file using bcp
    Madhivanan, Jan 28, 2011
    #6

  6. satya Moderator

    Why use BCP when SSIS provides the need to handle such action.
    satya, Feb 7, 2011
    #7

  7. Madhivanan Moderator

    [quote user="satya"]
    Why use BCP when SSIS provides the need to handle such action.
    [/quote]
    If the table has to be moved to another RDBMS which is not in the network, my methods would work well.
    Madhivanan, Feb 8, 2011
    #8

  8. satya Moderator

    Still SSIS is best bet here as the export or import it uses the bulk copy method [:)].
    satya, Feb 8, 2011
    #9

  9. FrankKalis Moderator

    The original questioner hasn't yet come back. I'm sure he has plenty of alternatives to choose from now. Let's wait for his feedback...
    FrankKalis, Feb 8, 2011
    #10

Share This Page