July 29, 2015 at 2:49 am
I need to schedule daily backup at 6:00am. I don't clearly how to do this. I'm on Sql Server 2008r2
Can you help me? Thanks in advance
July 29, 2015 at 3:46 am
1. Use Microsoft SQL Server Management Studio to create a new Maintenance Plan.2.In the object explorer go to the folder Management > Maintenance Plans. 3.This will open the designer. 4.In the Toolbox you will find a task named Back Up Database Task, drag this onto the designer. 5.Right click 'Back Up Database Task' select edit from the context menu. Details are here https://msdn.microsoft.com/en-us/library/ms189647.aspx and http://sqlbak.com/blog/scheduling-backups/[/url] There is a script, which can also be useful for this https://ola.hallengren.com/[/url]
July 29, 2015 at 4:01 am
There's a service that gets installed with SQL Server called SQL Agent. You can use that to schedule your backups. Here's the documentation on the service. It's very straight forward to use.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2015 at 6:54 am
In addition to Grant's comment, you can implement the backup jobs described on the following link. Just make sure to modify the jobs to match your schedule. This was a suggestion that was given to me by our SR DBA and it completes the task like a charm. Download the files....
July 29, 2015 at 12:16 pm
In addition to Grant's comment, you can implement the backup jobs described on the following link. Just make sure to modify the jobs to match your schedule. This was a suggestion that was given to me by our SR DBA and it completes the task like a charm.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply