Solved

What is the best way to schedule daily SQL 2008 R2 backups?

Posted on 2011-03-03
7
1,033 Views
Last Modified: 2012-05-11
I would like to set up automated daily SQL 2008 R2 Server Backups of two SQL databases. What is the best way to accomplish this?
0
Comment
Question by:PDSWSS
7 Comments
 
LVL 39

Expert Comment

by:Aaron Tomosky
ID: 35031536
Sqlcmd is a command line utility that can backup a db. Write a little batch file and run it using task scheduler.
0
 
LVL 7

Accepted Solution

by:
Cboudroz earned 450 total points
ID: 35031592
use the maintenance plan wizard in SQL Server Management Studio
http://msdn.microsoft.com/en-us/library/ms191002.aspx


0
 
LVL 9

Assisted Solution

by:kaminda
kaminda earned 50 total points
ID: 35034368
With SQL Server's Maintenance plan wizard you can do this. It is highly recommended and the Agent Job log which you can monitor regularly. In that you can even setup deleting or archiving old backup files. It is really a great tool.
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 9

Expert Comment

by:mayank_joshi
ID: 35034492
as stated by ' Cboudroz' maintenance plan is the best option in my opinion.
0
 

Author Comment

by:PDSWSS
ID: 35036701
Thanks. Looks like the Maintenance Plan Wizard is the way to go.

How would I  change settings from Full Backup to Differential backup?
0
 
LVL 7

Expert Comment

by:Cboudroz
ID: 35037810
You can modify the actual maintenance plan and in the "Back Up Database Task" you can change the back up type from "Full" to "Diffential"


or in the Creation wizard it's the second tab "select maintenance plan tasks"  - check Differential

0
 

Author Closing Comment

by:PDSWSS
ID: 35046727
Thank you.
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question