01-12-11, 05:15 #1Registered User
- Join Date
- Jan 2011
Unanswered: What is the best method for backup and restore VLDB and auto-delete data from the bac
Hi, I have 1 database which the size of minimum of 60 Gb in 1 physical server and I have another empty database in another physical server. What would it be the best backup and restore from the this VLDB - 1 database of 60 Gb in size in 1 physical server to 1 empty database in another physical server ? I have try Mirroring but it requires all the table to be first have keys and the tables in the database of 60 Gb in size most of them does not have any keys at all. I'm now considering Log Shipping or Replication or the normal Backup and Restore process.
I have try Log Shipping and it looks fine but would it effects the performance of the production database server if to be run it daily office hour or suggested to run after office hour as in the evening? Would Replication good too or not? I have try the normal Backup and Restore process and my main concern is would the transaction log increase in size if I run that process?
I have another issue where after I have run either the Log Shipping or Replication or the Backup and Restore process, I need to auto-delete data from the database of 60 Gb in size. Let's say the database of 60 Gb have data dated from January 2009 till December 2010, I would like to backup and restore to the empty database in 4 separate database which 1 have data dated from 1 Jan 2009 till Mar 2009, 2 have data dated from April 2009 till Jun 2009, 3 have data dated July 2009 till September 2009 and the 4 have data dated dated October 2009 till December 2009 which will make the database of the 60 Gb to have data dated 1 January 2010 till December 2010.
Is there any best method for backup and restore VLDB and auto-delete data from the backup database?
01-12-11, 12:24 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
So you want to have a database per date range?"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."