Post reply

Hi All

  • May 10, 2010 at 10:51 pm

    #140079

    Hi All,

    can anyone tell me how can i take the backup of only on e object in a database, like just one table

  • May 11, 2010 at 1:42 am

    #1165379

    You can't with the native tools. Best you can do with the native tools is a file backup (backup of a single database file). Check the requirements and limitations on Books Online if you go that route.

    Otherwise you could bcp the file out to a csv.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 11, 2010 at 2:13 am

    #1165389

    Also if you just wanted to make a copy of it you could always "select * into table2 from table1"

    to the same database or another, wont help if you actually want a file on the file system though

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

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