Professional Web Applications Themes

Archiving - Microsoft SQL / MS SQL Server

SET ANSI_WARNINGS OFF -- David Portas ------------ Please reply only to the newsgroup -- "Johny" <com> wrote in message news:phx.gbl... ...

  1. #1

    Default Re: Archiving

    SET ANSI_WARNINGS OFF

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Johny" <com> wrote in message
    news:phx.gbl... 


    David Guest

  2. #2

    Default Re: Archiving

    Sorry. Wrong thread.

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "David Portas" <org> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    David Guest

  3. #3

    Default Re: Archiving

    If you need the ability to merge previously archived data with current data
    and you have some criteria (such as a date) on which you can logically
    segment your tables then you could consider using partitioned views. You can
    partition a view across databases from which data could then be deleted or
    restored as necessary.

    http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_06_17zr.asp


    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --


    David Guest

Similar Threads

  1. Archiving
    By jazzcar in forum Macromedia Contribute General Discussion
    Replies: 1
    Last Post: June 5th, 11:45 PM
  2. Archiving in 7
    By BaileyBurger in forum Coldfusion Server Administration
    Replies: 1
    Last Post: May 22nd, 03:28 PM
  3. Replies: 1
    Last Post: February 11th, 12:08 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