January 12, 2011 at 12:51 am
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.
January 12, 2011 at 1:33 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1046305-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply