Avatar of Shiv Saha
Shiv Saha
Flag 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.
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Alpesh Patel

8/22/2022 - Mon
Kyle Abrahams

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
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
Zberteoc

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Steve Wales

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Alpesh Patel

For minimal data loss.

1. Take full back up
2. Periodically take differential backup
3. Daily take log backup.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck