data warehousing

We have some old data that we are not using, it's taking so much space for
no reason, we want to keep them seperately from the new data so we 're
planning to insert them to a seperate table and still make them accessible
by the customers whenever they want to access the arcieved data. Now I
really need your advice on this. What is the best way to do this? There 's 8
million data on this table, how do I implement this arcieving system?
Thank you.I would put it in a separate database... that way it could be backed up and
restored separately... It would also make it easier to move to another
server if (later) you decided to doso.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fulya Erol" <ferol@.no.nospam.mezun.com> wrote in message
news:eU3qGrAwDHA.3744@.TK2MSFTNGP11.phx.gbl...
> We have some old data that we are not using, it's taking so much space for
> no reason, we want to keep them seperately from the new data so we 're
> planning to insert them to a seperate table and still make them accessible
> by the customers whenever they want to access the arcieved data. Now I
> really need your advice on this. What is the best way to do this? There 's
8
> million data on this table, how do I implement this arcieving system?
> Thank you.
>