Post reply

Restore Table in SQL 2000

  • July 1, 2003 at 5:21 pm

    #64832

    In earlier versions of SQL Server, you can restore certain tables in EM. Does anyone know how to do the same thing in SQL 2K?

    Thanks.

  • July 1, 2003 at 10:18 pm

    #463864

    You're out of luck sorry.

    You'll need to restore the database somewhere else and extract the table you need, then move it into the live database.


    Cheers,
    - Mark

  • July 2, 2003 at 5:10 am

    #463898

    You could place the table into its own filegroup. SQL2000 allows the restore of individual filegroups.

    Make sure you restore the table and its indexes and consider any referential integrity/foreign key issues.

  • July 2, 2003 at 7:03 am

    #463911

    This feature has been discontinued from SQL 7.0 for the reasons Tim had explained above. This is one hell of a feature we missed from 7.0.

    .

  • July 2, 2003 at 11:58 am

    #463967

    Thanks for the input. Is the feature added back in SQL Server 2003?

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

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