Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 ?

Thanks.

share|improve this question
add comment

2 Answers 2

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. –  Albert Widjaja Apr 13 '11 at 4:03
add comment

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

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

Your Answer

 
discard

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.