schedule backup

  • 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

  • 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]

  • 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

  • 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....

    https://ola.hallengren.com/sql-server-backup.html

  • 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.

    https://ola.hallengren.com/sql-server-backup.html

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply