0

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.

2 Answers 2

3

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"

1
1

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

1
  • Glad to help, AW.
    – joeqwerty
    Apr 14, 2011 at 2:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .