?
Solved

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

Posted on 2011-03-03
7
Medium Priority
?
1,041 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 1800 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 200 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

864 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