Post reply

Taking Backup Of table

  • September 17, 2012 at 11:53 pm

    #281490

    Hi all,

    I have a table which has some 10 million records. Now i want to take backup of this table but backup of 10 million records is not required we only need back of 1 million records? In this case what are we going to do.

    I know how to take full backup of database but how to take backup of this 1/10 th data

  • September 18, 2012 at 1:50 am

    #1538934

    back the data you want up into another table

    something like this

    select * into tablename_backup from tablename where somecol = 1000

  • September 18, 2012 at 2:21 am

    #1538949

    anthony.green (9/18/2012)

    back the data you want up into another table

    something like this

    select * into tablename_backup from tablename where somecol = 1000

    Hi since i am newbie in SQL Server, This solution seems to me as a long path which may not be true but what can be the another way of doing this.

  • September 18, 2012 at 2:24 am

    #1538950

    You cannot take a backup of an individual table or a subset of that tables data by any normal native backup routines.

    The only options are to export the data into a flat file or another table / database.

    For flat file use the import / export data wizard or SSIS

    For other table / database use the soltution I have already provided above.

    Otherwise backup the whole database.

  • September 18, 2012 at 5:42 am

    #1539021

    another option is the bcp utility with the 'query' parameter

    ---------------------------------------------------------------------

Viewing 5 posts - 1 through 4 (of 4 total)

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