General discussion


Help a novice with SQL Server 2K?

By Al@Baxter ·
I have a SQL Server 2000 that has 6 databases (one for each production machine) which holds data for each part processed. I developed this mainly to start learning about SQL Server and management liked it, so they want to use it as a tool to look at the process on an "as needed" basis. What I haven't developed yet is how to archive the data and then automatically delete it out of the database(s). The frequency of this archive/purge of the 6 DB's is probably daily or weekly. I don't think that there will be a need for on line access to this historical data and the archive can be in Access or Excel. The parties using this data aren't using anyhing more advanced than that to analyze the data. From what I've looked at so far, DTS may be part of the answer.

Will anyone be so kind as to give me any ideas on where to start (or how to put it all together)? The time I have to spend on this "learning experience" is considerably less than when I originally started. That is why I'm soliciting help at this point.

Any help would be greatly appreciated.

Thank You for your attention.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Not an expert but some ideas

by brabo In reply to Help a novice with SQL Se ...

I found that I could do something similar using a script to run a stored procedure and SQL's schedule agent to delete data. No doubt the experts have a more elegant way.

Related Discussions

Related Forums