Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

automate full database backups with sql server 2008 r2 EXPRESS

Posted on 2012-03-29
2
Medium Priority
?
641 Views
Last Modified: 2012-04-02
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?
0
Comment
Question by:jsctechy
2 Comments
 
LVL 15

Accepted Solution

by:
Anuj earned 2000 total points
ID: 37782329
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
 
LVL 25

Expert Comment

by:TempDBA
ID: 37782756
I personally like the suggestion from expert Anuj..
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

916 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