Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ggarza75
Yak Posting Veteran
50 Posts |
 Posted - 2009-06-22 : 13:11:45
|
| I need some assistance from some fellow DBAs. I currently started with new company (CPA firm). I was just handed the task of coming up with a plan to archive old records from the database.What my manager wants me to do is archive any closed clients (inactive) into another database, which we will keep for a certain amount of years.Our users use a custom-made application to make all their entries. My manager would also want the application to tell SQL which clients should be archived.I'm not sure what I need to do on the SQL end to make this happen. I guess my question is, what's the best route I can make this happen. Hope all this made sense.Thanks any help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-22 : 13:34:08
|
| one way to do is to add an audit column like lastmodified to your table and archive based on its value. you may also look for status value to identify the inactive records. |
 |
|
|
|
|
|
Archiving Old Records