October 11, 2010 at 8:22 am
There are three databases located on three separate servers around the country (Miami, Los Angeles and New York). These three databases are roughly 20-30 Gb. The current practice is to use transaction log shipping (actually a modified process that compresses/decompresses the logs for shipping and application) to update backup (data repository) copies of each of the three databases on a central SQL server in a different New York location.
The three production databases are backed up nightly, as are the data repositories. The growth of the amount of data has created performance issues with the production databases.
What I would like to do is a) turn off log shipping, b) delete the excess data from the production tables, and c) turn log shipping back on.
The questions I have are:
Can I apply transaction logs to the database if the number of records in the tables are different?
The data to be deleted (all records over six months old) will not be changing, so will the transaction logging application process fall over?
Will I be able to turn off logging in order to delete the old data, or will the data be deleted from the repository once I delete it from the production database and then turn log shipping back on?
Am I doing this entirely the wrong way? Note that I did not set up this database backup scheme (log shipping) and am not free to make any change that I wish.
October 11, 2010 at 9:08 am
are you saying that the amount of data is causing the full backup to take too long ? or is the problem that the databse is performing badly?
becasue at 20 - 30Gb i can't really see the backups taking that long as the database are not very large
October 11, 2010 at 9:13 am
Turning off & on logshipping will require reinitialization. (full backup + new logfiles).
Mayhaps is it possible to delete the old data in sustainable batches for logshipping?
October 11, 2010 at 11:06 am
Yes, the backups are affecting performance on the servers - this is a 24/7 operation, so there isn't really any downtime.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply