troubleshooting Question
What type of Scheduled Backup I should choose for SQL Server 2008
Shiv Saha
asked on
asked on
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.
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.
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.