Hi guys, we lost one of our IT guys and all of SQL SERver will be falling on me. He use to handle the backing up with BackUp Exec but now I will be handling it. I will not use Backup Exec I will use SQL Server itself. I was thinking of creating a Maintenance plan for all the user databases, Full Backup twice a week and Differential backup three times a week, setting the Database at Simple Recovery since we are nto the interested in Point in Time recovery. No one is entering data on a daily basis all throught out the day. Data is entered every other day I would say.

Does this sound like the correct approach guys??