Solved

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

Posted on 2011-03-03
7
1,029 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 38

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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

New! My Passport Wireless Pro Wi-Fi Mobile Storage

Portable wireless storage to offload, edit, and stream anywhere.

High-capacity, wireless mobile storage designed to accompany professional photographers and videographers in the field to easily offload, edit and stream captured photos and high-definition videos.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

867 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now