archiving data

From: "jon" <jonathan.waterhouse@xxxxxxxxxxxxxxxxxx>
Date: Wed, 28 Feb 2007 16:30:44 -0000

Hi all,

Ive got a SQL database which accumulates about 4 million records each year.
This amount causes my PC to slow down when searching, and my hard drive is
getting fuller.

To overcome this problem I have to delete half the records each year (2
million) which takes quite some time.

My question is - is it possible to archive some of the SQL database each
year onto another hard drive. The archived data should them be removed from
the original SQL data base.

I Would also need to be able to view, sort and search this archived data on
another machine in excell or something.

Hope someone can help.

Thanks

Jon

.

Prev by Date: Referencing combo box column
Next by Date: Data Provider Could Not Be Initialized
Previous by thread: Referencing combo box column
Next by thread: Data Provider Could Not Be Initialized
Index(es):
- Date
- Thread

Relevant Pages

Re: Incoming Faxes - Sharepoint Services
... The documents stored on Sharepoint are in a SQL database, ... find them simply by searching the server. ... > regards Sharepoint Services because we have a document listed which we are ...
(microsoft.public.windows.server.sbs)
Formatting phone numbers in gridview
... I'm using VWS Express to do a web page on a sql database for a friend. ... Most documentation I have found has come after a tremendous amount of searching. ...
(microsoft.public.dotnet.framework.aspnet)