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
  2. jdgonzalez New Member

    select *into MyNewTablefrom MemberInfo
  3. Luis Martin Moderator

    Welcome to the forums!.
    Where do you want to backup that table?
  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.
  5. Madhivanan Moderator

    1 Generate script for that table
    2 Export data to text file using bcp
  6. satya Moderator

    Why use BCP when SSIS provides the need to handle such action.
  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.
  8. satya Moderator

    Still SSIS is best bet here as the export or import it uses the bulk copy method [:)].
  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...

Share This Page