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.
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
Last Comment
Alpesh Patel
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
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.
ASKER CERTIFIED SOLUTION
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.
For minimal data loss.
1. Take full back up
2. Periodically take differential backup
3. Daily take log backup.
1. Take full back up
2. Periodically take differential backup
3. Daily take log backup.
I could see you do differentials every hour between 7 & 7 and then a full backup at like 1:00 AM