The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
1answer
130 views

Moving Transaction Data To Another Database For Reporting Purpose

We got a requirement from our developer group, to do the followings: Frequently (every 30mins) move the transaction data out of live database to another database Secondary database will be utilize ...
2
votes
1answer
52 views

How to archive a whole database?

I have a database that is not going to be used anymore but that needs to be kept around for a long time. I'd like to remove it from the production system. My goal is to save storage space when ...
0
votes
0answers
15 views

MongoDB Backup & purge [duplicate]

I'm exploring solutions for a basic dbadmin need : periodically backing up and purging data in MongoDB. Basically, I need a logrotate for mongodb. I have a backend program filling a collection. I ...
0
votes
3answers
57 views

Schema Design with “Seasonal” Data

I am developing a SaaS web application for School Management. What I need help is this: The whole application is purposed for the current year that the School is in. However, some data and ...
0
votes
1answer
42 views

How to keep archive table accessible for some users which is not frequently accessible?

I have partitioned my table based on some boundary ranges. My Database is built at MSSQL server 2008 R2. I have done partitioning for a table which has 40 million records in it. Now it's time to ...
0
votes
0answers
24 views

Data archivation - UNION from two hosts

I have stats in 4-node cluster and database now have about 2.4TB. I want to make "archive server" and move old data from cluster. My idea is on cluster create FEDERATED table from archive and if ...
1
vote
0answers
45 views

pt-archiver and foreign keys?

How does pt-archiver handle foreign keys? Does it archive associated data? (seems not but the documentation is not very clear to me) And if not, how could one perform an archive of a table with all ...
4
votes
3answers
183 views

What is the proper way to store a full table of data outside of a database? It needs to be able to be restored as well

I have a large SQL Server 2005 database that hasn't had the best maintenance over the years (I just took it over recently). There are around 100 tables that can be completely removed from the ...
0
votes
0answers
257 views

Oracle Archiving deleted rows via trigger and trigger logging if error

I created table in new schema/user CREATE TABLE archive.table1 ( id NUMBER(10), name VARCHAR(45), created_at DATE, updated_at DATE, deleted_at DATE ); I granted access to that table for ...
1
vote
0answers
26 views

periodic data move from local server to remote server

I have a local PostgreSQL server that is recording data on a solid state drive of less than 8 GB free space on a Windows 7 embedded 32 bit machine. In order to make a backup and store large data I ...
0
votes
0answers
264 views

Archive Logs not applied on Primary Database

I have a oracle database and some archive logs in the primary database have not been applied. When I run SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG order by SEQUENCE# I get the following ...
1
vote
2answers
133 views

Archiving data from logging db (high writes, no reads)

I have a logging database with a few lookup tables and one massive event table that has 79 million rows. On busy days my code inserts over 3 million rows, so the event table would be enormous in ...
0
votes
0answers
105 views

how to archive old entries from mysql on rds

I have an AWS RDS MySQL DB. I have ec2 instances and an s3. What I would like to do is only retain 60days old data and archive the rest. I'm still new at this so I'm not really sure what to do. What ...
1
vote
1answer
462 views

How does Postgres know which logs have been archived?

I'm asking this because Postgres was hard-stopped yesterday, and I fear that there could be partial / corrupt data in one of my archived log segments. I'd like to simply delete the logs from my slave ...
0
votes
0answers
120 views

Tape rotation strategies

I am trying to find a tape rotation strategy that would be optimal under the following conditions: Backup Media Rotation strategy should support the following: Media Archives required ...
0
votes
2answers
412 views

Using MySQL InnoDB as an Archive

My site has a main MySQL InnoDB table that it does most of its work on. New rows get inserted at a rate of 1 million per week, and rows older than a week gets moved over to an archive table on a daily ...
0
votes
2answers
1k views

Delete and archive old data from several related tables

Our schema looks like this: table tblTrip: stores start and end trip date and time table tblTripData: keeps all the trip data table tblTripEvent: stores events related to the particular trip. Then ...
1
vote
3answers
436 views

Design for archiving a sorted list (with ability for a few INSERT)

I have a somewhat static sorted list of words which I want to save in a database table: -- simplified! -- Note: the rank/order of each item is NOT calculable from other values! CREATE table words ( ...
2
votes
2answers
315 views

Support ticket system - when/how to move old tickets?

I don't have access to the partitioning feature, but consider a support ticket system with tens of thousands of tickets being opened everyday and taking about a week to a couple of months in getting ...
2
votes
1answer
985 views

Archive database on Postgres

I have a table with more than 60mio records, where every month I have to add about 2-4 milions. It's not insert only table, I need to read from it and update recently added rows (status changes, ...
8
votes
1answer
2k views

Database archive solutions

In continuation to a question posted by me on Is it a good idea to move high-volume and highly-accessed tables to a separate database?, am looking out for different techniques/solutions available for ...
2
votes
1answer
978 views

Data archival strategy that handles schema changes?

I am working with a legacy application that has about ten years of customer data. A majority of this data is not used in day-to-day operations but there is a business requirement to have the data ...