Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2011
    Posts
    1

    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?

    Thank you.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    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."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •