I have number of SQL 2005/2008 databases to manage here. I am new to SQL server so I am looking for a white paper or a backup solution from an expert.
I need to address :
1) How to create a centralised backup environment consisting of hundreds of SQL databases? I should able to schedule backups from this console.
2) How to monitor/report failed backups every night?
3) What kind of compression, encryption technologies are available
4) Also a restore from one server to another should be possible