<div>
you can use this workaround;<br />
<br />
<a href="http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express" rel="ugc">http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express</a><br />
<br />
or sqlcmd together with windows task scheduler
</div>


you can use this workaround;

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

or sqlcmd together with windows task scheduler

<div>
Thanks for writing out the command line. It really helps a novice like me.<br />
pat
</div>


Thanks for writing out the command line. It really helps a novice like me.
pat

<div>
<div class="content wysiwyg-content">
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?<br />
thanks,<br />
pat
</div>
</div>


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

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.