June 13, 2008 at 1:18 pm
I am newbie to Database Archive.
I did not know how to perform purge or archive on production database.
I am being assigned to clean some production data that running on sql server 2000 databases .
Technical plan.
Can you advise any solutions from sql perspectives that I can implemented?
June 13, 2008 at 1:42 pm
it all depends if you need the data to be available. This is a very general question that is difficult to answer. You have to get the business to tell you which data they don't need immediately available - then you have to find out how and if they want to see the archived data.
You can use a copy database which has all data over 1 year old for example - you could use a combination of filegroups and partitioned tables, just filegroups, just partitioned tables.
Then you need to figure out the best way to move the data and then delete from the prod system. You can also spread your data over different speed storage - lots of options.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 13, 2008 at 1:42 pm
For a quickstart:-
Identify the tables that need to be purged and the deletion criteria.
Manu
June 13, 2008 at 1:51 pm
Thanks for quick advise and reply. I will start to investigate the tables.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply