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 |
|
harlowhair
Starting Member
1 Post |
 Posted - 2007-09-18 : 16:44:28
|
| Hi,I currently maintain a fairly busy database running on SQL 2k5 and need to implement an archiving solution. I would like to replicate the structure of the database each day (a lot of development goes on so there are numerous changes), and also the data in a separate database.I would also like to keep the main 'live' database only containing the most recent 3 months worth of data which will help keep it fast and manageable - is it possible using replication to append all data to the destination DB?I have looked at a number of programmatical approaches and am actually playing around with writing my own system in .net to do this, but thought I should explore if there is a better and more correct way to do it first.Thanks in advanceRob |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-18 : 23:09:40
|
| Yes, replication can keep you a copy of the db on another server. If don't need real time copy, even backup/restore will work. For archiving, you can move old records to archive table in same db or another db. |
 |
|
|
|
|
|
Whether to use replication?