Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 142
  • Last Modified:

Back Up Strategy

Hello
          Let me explain the scenario
1: I have developed a system for an org, the org wants to keep the records for the previous five years, records before these five years must be removed from database, but backup of this removed data should be available on CD or any media.
2: their another requirement is that in future they must have the way to access that removed data, just to query or see the details.

its easy to back up &  then remove,
now the problem for me is that how to restore it again on the current database, coz it will disturb the current data by over writing old data,
i dont wanna restore from old backup, then again from new backup.
if i use another database  for viewing these removed/backed up data it will be a great time consuming task,
what to do
I hope my problem is clear

Regards
0
jawad_ashraf
Asked:
jawad_ashraf
  • 3
  • 2
1 Solution
 
arbertCommented:
I would create an "Archive Table" and move the records there.  You would just need to remember and archive any of the "child" records as well.

Another option, if you can keep the data online is to partition the table based upon a date value in your table.  Horizontal partitioning to be more exact.

Brett
0
 
jawad_ashrafAuthor Commented:
thanks brett
first option is clear but not the second one
date based partition?
horizonal partition?

and one thing if i use the first technique , the archive tables will contain all the old records,
that will use more disk space, and if i take different backups on CDs and then reload them at the time when required, it will save the space. can i use another duplicated Db to be restored
from these CDs backups.when checked can be unload

thanks

jawad
0
 
arbertCommented:
Yes, you can restore to a different database.  For storage being as cheap as it is, disk space seems to be a poor point for an archive--performance yes (which can be handled by partitioning), but storage no.....

Here is a really quick overview of partitioning:

http://www.sqlteam.com/Item.ASP?ItemID=684


SQL2005 will have partitioning "builtin" so it isn't as difficult to implement.

Brett
0
 
jawad_ashrafAuthor Commented:
thanks
Ok I ll check it and tell u again
0
 
jawad_ashrafAuthor Commented:
hello again
 if i user the strategy of restoring Backup over another Database, will it be possible to restore from a backup which is related to another Database

thanks
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now