Professional Web Applications Themes

Backup tables - Microsoft SQL / MS SQL Server

I thought I remembered back in the 6.5 days when you could backup just a table. Is that still possible? We have a database over 150 gigs and would like to run a dbcc reindex on some of our larger tables. Last time we did it in production, it blew out our logs and messed up our log shipping. We want to pull out the table in the state its in now and try and run the dbcc reindex. But we don't have room to restore the whole database. Any suggestions? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate ...

  1. #1

    Default Backup tables

    I thought I remembered back in the 6.5 days when you could backup just a
    table. Is that still possible?

    We have a database over 150 gigs and would like to run a dbcc reindex on
    some of our larger tables. Last time we did it in production, it blew
    out our logs and messed up our log shipping. We want to pull out the
    table in the state its in now and try and run the dbcc reindex. But we
    don't have room to restore the whole database.
    Any suggestions?



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Bob Guest

  2. #2

    Default Re: Backup tables

    Place the table in its own filegroup and to a filegroup backup. You can then do a partial restore and run the DBCC against it.

    --
    Tom
    --------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com.sql
    ..

    "Bob" <com> wrote in message news:phx.gbl...
    I thought I remembered back in the 6.5 days when you could backup just a
    table. Is that still possible?

    We have a database over 150 gigs and would like to run a dbcc reindex on
    some of our larger tables. Last time we did it in production, it blew
    out our logs and messed up our log shipping. We want to pull out the
    table in the state its in now and try and run the dbcc reindex. But we
    don't have room to restore the whole database.
    Any suggestions?



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Tom Guest

  3. #3

    Default Re: Backup tables

    'Fraid not.

    --
    Tom
    --------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com.sql
    ..

    "Susan" <com> wrote in message news:00a501c368d7$26599bd0$gbl...
    The table in question is running in production. We do have
    plans to move out the bigger tables to their own
    filegroups, but are unable to make that change now.
    Anything else???

     
    backup. You can then do a partial restore and run the
    DBCC against it. 
    news:phx.gbl... 
    could backup just a 
    a dbcc reindex on 
    production, it blew 
    pull out the 
    reindex. But we 
    *** 
    Tom Guest

  4. #4

    Default Re: Backup tables

    An option is to run DBCC INDEXDEFRAG instead. It typically procuces less log records (possibly a lot
    less). The difference depends on the fragmentation level of the table.

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


    "Susan" <com> wrote in message news:00a501c368d7$26599bd0$gbl... 
    > backup. You can then do a partial restore and run the
    > DBCC against it. 
    > news:phx.gbl... 
    > could backup just a 
    > a dbcc reindex on 
    > production, it blew 
    > pull out the 
    > reindex. But we 
    > *** [/ref]


    Tibor Guest

Similar Threads

  1. Replies: 2
    Last Post: March 9th, 11:54 PM
  2. Using CFML to Backup (duplicate) tables into the same orSecond MDB
    By bigbrain28 in forum Coldfusion Database Access
    Replies: 1
    Last Post: October 31st, 09:26 PM
  3. loop - begin backup, end backup Oracle 8.1.7
    By Matthias Arth in forum Oracle Server
    Replies: 1
    Last Post: December 27th, 08:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139