Archiving the data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Archiving the data

Hi! I am working as a Web Developer as well as looking after Database Maintainance part.
There is a need for me to move the old data from my production database to some other server from which clients can view the same. That way i am trying to reduce the load from the Production Database…. Can you tell me how can I archive the old data based on some date criteria and move to some other server as well delete that old data from my production database…. Do we have any Stored Procedure ready for that job…. or any other method?
you can transfer data to another server by DTS. From DTS you can give a criteria for the data which you want to transfer data —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

http://vyaskn.tripod.com/sql_archive_data.htm as a good start. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi Satya, Thanks for the Reply.
I used the same site which you have mentioned but with that site i am able to move data from one database to other.. but the site didnt given any information about moving the data from one server to other… and My need is exactly same like that.
Hi, Thanx for the reply.
Okey I will try to work with that… i tried to work with the code given in http://vyaskn.tripod.com/sql_archive_data.htm, but the code seems to be work with the database on same server, so not of my use.
Another link from same sitehttp://vyaskn.tripod.com/moving_sql_server.htm for your joy. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>