What type of Scheduled Backup I should choose for SQL Server 2008
Posted on 2012-12-21
I am looking for some advice on what type of Scheduled Backup I should choose. I will be setting up a SQL Server 2008(Std) and managing the server soon. About 5-6 users will be accessing this server on a daily basis mainly during 7am-7pm . I'd like to backup the Database to one of my network locations (another File Server). Main idea is, in case there is an event like server crash etc. , I should be able to restore the databse with minimum data loss.
So my questions would be:
1. Should I choose Backup features that SQL has or should I choose a 3rd party software?
2. If I choose SQL BKP, considering my scenarios, what type of BKP(Full/Differential) will be best?
Thanks for your advice and help.