I'm new to automating SQL 2008 R2 backup. Is there a script or a way for me to achieve this.
I would like to achieve the following.
1. Automate Database backup to a local drive on the host machine nightly.
2. Automate Database backup to a shared drive on a file server on the domain.
3. I want to be notified by email of the backup. May be tell me that it is successful.
4. Automate removal of database that are x days old for the purpose of cleanup.
My Servers are windows 2008 R2 and run MS SQL 2008 R2 SP1.
I have standalone host machines as well as a database hosted on a two nodes Cluster.
Any help much appreciated.