Post reply

backup

  • May 9, 2008 at 12:16 am

    #190406

    Hello,

    i sathish can any one tell backup only table.

    Regards,

    sathish.

  • May 9, 2008 at 12:32 am

    #812825

    Not with any SQL backup tool. They allow you to backup the entre database or a file of the database.

    You could export the table to CSV. You could make a copy of the table in another database.

    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 9, 2008 at 12:52 am

    #812833

    Hi sathish

    We can do by query..

    Select * into databasename.dbo.tablename_bakcup

    from tablename....

    by this we can take a back of one table... not with tools.

  • May 9, 2008 at 1:13 am

    #812839

    By using "select into " statment you will only get the columns and the data. It will not create Primary keys , indexes etc.

    "Keep Trying"

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

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