SQL Backup of impresario and impresario_cci

My preference is to do a Full backup nightly at about 22:00; and a Transaction Log backup every 10 minutes during the day, keep all of those in the backup folder for about 2 days ( longer if you’ve got enough space), and back up the backup folder/s off to tape every night after the full backup has completed.

But really,  relying on backups with Tess these days would make me very nervous – God help us if we ever had to actually go back to one. It’s really just there for total last-choice disaster use. Even if you only lost 10 minutes of data, because you’ve got the transaction log backups to run back in, it’s still going to be an almighty mess.  I think we  should all be mirroring the data in real time – preferably off-site (or doing some sophisticated  block-level real-time backup to a data centre somewhere else, if you’ve got access to that sort of resource.)

________________________________
Ken McSwain

Systems and Technology Manager

Australian Chamber Orchestra

ken.mcswain@aco.com.au

Ph   +61 2 8274 3833 ::  Mob +61 418 659 360 :: Fax  +61 2 8274 3801

PO Box R21, Royal Exchange NSW 1225

2 East Circular Quay, Sydney NSW 2000

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Martin Keen
Sent: Monday, 26 September 2011 13:50
To: Ken McSwain
Subject: [Tessitura Technical Forum] SQL Backup of impresario and impresario_cci

Folks,

I want to ensure that I am backing up our Tessitura databases correctly and fully on a nightly basis.  Does anyone have recommendations (or better yet) documentation on how this is best achieved from within MSSQL as a nightly task?

Many thanks (as always) for any help!

Martin

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!