Post reply

Table backup

  • December 18, 2003 at 4:56 am

    #65766

    Is there any way to backup individual tables with SQL 2K.

    The tables in question have auto identity columns

    Rgds

  • December 18, 2003 at 6:22 am

    #486907

    No unless you have that table in a separate file and separate filegroup, allowing you to backup a single file wich contains a single table.

    You can also export the table as a "backup". You can use BCP, wich is the fastest tool.

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

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