I am not really a DB guy. We don't have any back up servers for our DataBase. There is a need for some kind of back up service which can take production back up daily once in the morning and once in the evening .
Any suggestions ?
If you just need basic backups they can be setup pretty easily from the maintenance plan interface.
http://msdn.microsoft.com/en-us/library/ms187658%28SQL.90%29.aspx
This link is more "wizardy"
http://msdn.microsoft.com/en-us/library/ms189036%28SQL.90%29.aspx
I use redgates SQL Backup, it's worked for years very reliably, easy to set up, and it does streaming compression, so your backups don't take too much disk space.