?
Solved

Can SQL 2008 R2 Express be set to make a backup file nightly

Posted on 2010-08-15
3
Medium Priority
?
583 Views
Last Modified: 2012-05-10
We are using SQL 2008 R2 Express to store less than 100 MB of data. Is there a way to set SQL to perform a nightly backup to the hard drive?
thanks,
pat
0
Comment
Question by:mpdillon
[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
  • 2
3 Comments
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 33442331
you can use this workaround;

http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express

or sqlcmd together with windows task scheduler
0
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 2000 total points
ID: 33442342
using task scheduler, the command should be something like

Sqlcmd -S .\SQLEXPRESS -q "backup database mydbname to disk = N'c:\backup\location\mydb.bak''

the trick is that the account used to run the scheduled task must be able to login to the sql server, and sql server must have access to the backup location
0
 

Author Closing Comment

by:mpdillon
ID: 33446946
Thanks for writing out the command line. It really helps a novice like me.
pat
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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…

764 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