#1
  1. No Profile Picture
    Contributing User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2003
    Posts
    45
    Rep Power
    16

    Getting Back Up Only Few Tables OF Sql Server 2000 Data Base


    HI sIR...
    CAN U tELL ME...
    hOW Can I get the BackUp of Only Few Tables of Sql Server 2000 Data Base......instead Of getting BackUp of Complete Database...?

    Plz Tell Me any Solution
    I sehll be very thankful to u
  2. #2
  3. No Profile Picture
    Contributing User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2003
    Posts
    45
    Rep Power
    16
    HI sIR...
    CAN U tELL ME...
    hOW Can I get the BackUp of Only Few Tables of Sql Server 2000 Data Base......instead Of getting BackUp of Complete Database...?

    Plz Tell Me any Solution
    I sehll be very thankful to u
  4. #3
  5. Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    Aug 2005
    Location
    Moscow, Russia
    Posts
    327
    Rep Power
    26
    1. Restore as another/new database or at another server.
    2. Data Transformation Services - Export or import data.
  6. #4
  7. No Profile Picture
    Mad Rater
    ASP Discoverer (100 - 499 posts)

    Join Date
    Sep 2003
    Posts
    126
    Rep Power
    18
    Another way is to create a separate filegroup and store the tables you need backed up on the separate filegroup. Then, you can backup this filegroup alone. Of course, this may necessitate you rearranging tables a bit, if you have an existing database.
    See http://www.informit.com/guides/conte...rver&seqNum=42 for more details.
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.

Similar Threads

  1. Need help with ASP SQL Problem
    By bleutiger in forum ASP Development
    Replies: 1
    Last Post: January 20th, 2005, 11:13 AM
  2. Need help with SQL Querey or Stored Procedure
    By bleutiger in forum SQL Development
    Replies: 1
    Last Post: January 20th, 2005, 06:16 AM
  3. Replies: 1
    Last Post: February 26th, 2004, 03:22 PM
  4. Downloading Image Data From SQL Server 2000 (C#.Net)
    By SethMW in forum .NET Development
    Replies: 0
    Last Post: February 17th, 2004, 12:42 PM
  5. Replies: 3
    Last Post: December 16th, 2003, 03:55 AM

IMN logo majestic logo threadwatch logo seochat tools logo