• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 591
  • Last Modified:

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

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
mpdillon
Asked:
mpdillon
  • 2
1 Solution
 
cyberkiwiCommented:
you can use this workaround;

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

or sqlcmd together with windows task scheduler
0
 
cyberkiwiCommented:
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
 
mpdillonAuthor Commented:
Thanks for writing out the command line. It really helps a novice like me.
pat
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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now