October 15, 2008 at 8:46 am
Then I just apply the transaction log backup to new database as I would normally?
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD
October 15, 2008 at 8:54 am
Yes, Restore Log NewDbName From disk=FilePath With {options}
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 15, 2008 at 10:07 am
Cool. What is the ramification for changing the recovery mode of you database?
We currently in full recovery mode in production mode. But every Sunday we run a maintenance task the rebuilds all indexes. We noticed that we end up a 80GB log when it completes. Would I gain anything if I set the recovery mode to BULKED_LOGGED during this period and would I impact my regular backups?
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD
October 15, 2008 at 11:27 am
I don't know as far as the question you are asking. I will comment that you probably don't need to rebuild all the indexes every week. If you search this site I'm pretty sure you can find a script that will do an intelligent index rebuild.
Of I were to change the recovery model of my database I'd do a full backup immediately after the change, run my jobs, set it back and do another full backup. Then your backup restore chain would begin at that point.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 15, 2008 at 1:47 pm
Thanks for all the advise. I have to figure something else out about the indexes because the database is too big for multiple full DB backups.
What would you recommed for us to transition from using a multiple t-log backups files to using a single log backup file and keeping our exposure to a minimum?
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply