automate full database backups with sql server 2008 r2 EXPRESS

hey guys
looking to automate backups of a sql 2008 r2 express database
i want to make a full backup every night and keep the past 10 backups
anyway to do this?
LVL 1
jsctechyAsked:
Who is Participating?
 
AnujConnect With a Mentor SQL Server DBACommented:
As SQL Server 2008 R2 express edition is missing SQL Server agent, you should depend on windows schedule for scheduling the backups. Prepare a query to backup your database and save it as SQL file, then create a windows batch file that executes this sql file in sqlcmd mode. using windows scheduler call this batch file and schedule it to run on every day.

For retention, this option is available in BACKUP Command.
0
 
TempDBACommented:
I personally like the suggestion from expert Anuj..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.