Link to home
Start Free TrialLog in
Avatar of Shiv Saha
Shiv SahaFlag for United States of America

asked on

What type of Scheduled Backup I should choose for SQL Server 2008

Hi,

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.
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

Depends on what hte users / business wants.

I could see you do differentials every hour between 7 & 7 and then a full backup at like 1:00 AM
Avatar of unsatiated
unsatiated

What size are the databases?  I normally perform full backups nightly in my production environments and backup logs every 15 minutes.  In case of an event, you can restore the last backup + each transaction log file to restore to any point in time prior to the last days crash.
SOLUTION
Avatar of Zberteoc
Zberteoc
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
For minimal data loss.

1. Take full back up
2. Periodically take differential backup
3. Daily take log backup.