February 22, 2011 at 1:55 pm
I am planning to archive and purge a lot of data from a larger[er] production database. I am asking for opinions based on experience of doing something similar. My thoughts are that since approximately 40 GB of data will be moved out of a 105 GB database that is normally in FULL recovery mode, it might be quicker to take a full backup, change the database to either simple or bulk-logged mode, run all the processes that move/purge the data then at the completion change the database backup to FULL recovery mode and take another full backup.
I tried changing it to simple mode for a similar situation on a test server/database and the log file still got filled up.
Would it work better to use bulk-logged mode or just leave it in full mode and continue to backup the log every 10 minutes? I'm just trying to find a way to speed it up a bit. It would also be good to minimize the log file growth and tempdb growth.
Any thoughts will be appreciated.
February 23, 2011 at 2:38 pm
simple just means it clears it when it is done
now the question here is it possible that you may need to do a point in time restore, if i remember right from a question of the day your full logs are lost once a bulk log transaction is created
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply