1
  • Archiving and Purging Data

    We deal with a very large database that grows at an avrage of 50GB a month. The current database size is 700 GB. All the transaction tables are horizontally partitioned to seperate filegroups assigned to a individual data files holding each months data. What would be the best strategy to retain...

    Roops15 pointsBadges:
  • Archiving a row of data into another database on SQL Server 2005

    I work on SQL Server 2005, and I need to archive a row and its relationship into another database. I know a script could be written to do this, but I would like to know if software exists that could be given the data row and then complete the archiving by itself. Is this possible?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing archived information in SQL Server or on a SAN

    My company is storing PC files in SQL Server in an image field, and this data has to be archived. Due to our retention policy, the size of this data could grow to as much as 5 terabytes total, spread over 500,000 to 1,000,000 records. Should we store this data in SQL Server in an image field, or...

    SQL Server Ask the Experts2,585 pointsBadges:
1

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