how to Automate the SQL Server 2008 Database and OLAP backup?

Question

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.

score 3 · Accepted Answer · answered Apr 13 '11 at 02:17

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"

ay yes, that'd be great with wizard. – Senior Systems Engineer Apr 13 '11 at 04:03 — Senior Systems Engineer, Apr 13 '11 at 04:03

score 1 · Answer 2 · answered Apr 13 '11 at 02:14

1

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

answered Apr 13 '11 at 02:14

joeqwerty

109,901
6
81
172

Glad to help, AW. – joeqwerty Apr 14 '11 at 02:12

how to Automate the SQL Server 2008 Database and OLAP backup?

2 Answers2