?
Solved

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

Posted on 2011-03-03
7
Medium Priority
?
1,039 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

649 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