Data archiving to additional server

Tags:
Data archiving
SQL Server 2005
We have two identical SQL Server 2005 databases. We need to archive data to another server over a network. What would be the best way to accomplish this? This is primarily required because data needs to be archived for at least five years. We don’t need the archive server for backup purposes, just for archiving the data. Please advise what will be the best way to do this.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Do you need the data in the primary server as well as the archve?
if so use log shippping or replication to copy the data across to the archive server

if not setup a SSIS task to move the data on a regular basis

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Aksieman
    No, data is only required in the archive. Data older than 6 months will be deleted from the primary server, but data must be kept in the archive for up to 5 years. Must I setup an SSIS taks for each table that needs to be archived? I guess so. so basically - create a table on the archive server for each table on the primary server for which data must be archived. create SSIS package to archive new data received since the last run on the SSIS package.
    60 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following