Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have SQL Server 2008 Enterprise SP2 x64 database in my Windows Server 2008 Enterprise, my question is how to perform automated backup for both database content ? eg. the MDF and the LDF as well as the OLAP database ?


share|improve this question
up vote 3 down vote accepted

Open SQL Server Management Studio 2008 and connect to your database server.
Expand Management > Maintenance Plans > right click Backups > New Maintenance Plan... > double click Back Up Database Task > double click the new task in the right hand pane and enter your settings for the backup here.
You can enter the databases and destination file/s here. I'm sure you can figure out the schedule settings and stuff. Try googling "sql server management studio backup task"

share|improve this answer
ay yes, that'd be great with wizard. – Server System Specialist Apr 13 '11 at 4:03

Create a SQL maintenance plan that backs up the databases on a schedule.

share|improve this answer
thanks for the pointer Joe – Server System Specialist Apr 13 '11 at 4:04
Glad to help, AW. – joeqwerty Apr 14 '11 at 2:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.