Solved

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

Posted on 2011-03-03
7
1,031 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
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…

840 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