I just realized that I'm not doing transaction log backups for the two Transcend databases (TPAU and TPAU Archive). Do you?
I also just found that the Report Server database transaction logs are being backed up every 15 minutes. Is that really necessary?
Is it okay to change the recovery model during business hours?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jeff Stahel Sent: Thursday, November 15, 2012 11:40 AM To: Gloria Ormsby Subject: Re: [Tessitura Technical Forum] TPAU Transaction Logs
When you install the TPAU database there is a script that Intrix specifies that is to be run that sets this database to simple recovery model. In the script they specify that "TPA likes the simple recovery model". We like to have a bit more recoverability than that, so have changed the recovery model to full and backup the trans log every hour.
I agree that the report server database does not need to be backed up so often. I have changed that one to simple recovery model and back it up nightly.
From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com> Sent: 11/15/2012 9:29:44 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
You should be okay once there is no backup running at that moment. It shouldn't stop the server/service or pause/hang anything.