troubleshooting Question

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

Avatar of Shiv Saha
Shiv SahaFlag for United States of America asked on
Microsoft SQL Server 2008
5 Comments2 Solutions198 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Steve Wales
Senior Database Administrator

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros