March 30, 2009 at 11:22 pm
hi Friends,
Actually i m not a DBA but the situation given to me is just perfact for this forum category....
I work in One of the product development Company..We have dveloped our ERP and we have many clients also....
We have Crystal reports as reporting tool and sql 2005 as backend..
Now See the scene is like this...
Few of our clients have 4-5 years Data gethered on their dastabse....
Now the database has become very large so it is responding slow for any damn reports execution...
Now as per the solution we thinking that we should break the current database in to 2 or 3 databases based on years means every two years data will have the new database....And also we should automate the data moving process based on the conditions like if its two years old it should move to the differnet server.
Now how to achive this is the question adn our problem?
Means first how to break this database and then how to automate the data moving on daily basis...
Thanks & Regards,
Mithun Gite
March 31, 2009 at 12:46 am
Hi,
Without knowing your database structure, you could create new databases based on date ranges and create an archiving job that will delete from the current database and insert into the archive database.
March 31, 2009 at 1:26 am
Dear Friends,,,,
I wanted to know about Data Archiving.....In fact we have one situation in which we want to keep only 3years older data on our production server...so as any data gets older then 3 years it should get deleted from production server and it should move to archive server.....all this should be automated....
I heared that we can achive it by data Archiving... but please provide me some information on it...
So can you suggest me the ways and tools if any?
Thanks in advance......
Regards,
Mithun Gite
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply