asked on

How to back-up a database automatically?

I would like to automatically back-up my database daily at 12:00AM. I would like the back-up files to be in "C:\backups" and the file name should be "databaseName_YYYYMMDD.bak" where "YYYYMMDD" is the year, month and day. For example, the following is what we should see in "backups":

databaseName_20081012.bak
databaseName_20081013.bak
and so on...

I don't mind writing the script in a batch file and then use the task scheduler to run it at 12:00AM daily.

harwantgrewal

Hi you dont have access to Managment Studio. As you can create Job in there and sechdule them.

Harry

dqmq

The standard way to do that is to create a Management Plan. A wizard will walk you thru the steps under the Management node of Object Explorer

killdurst

ASKER

Ok I see the Management node under Object Explorer, but when I right click on it I only see "Refresh". How do I access the wizard?

harwantgrewal

Probably you user is not in SysAdmins group thats why you couldn't see anything there. Attached is the snap shot of how it looks.

Harry
14-10-2008-4-42-37-PM.png

dqmq

Righto...you need the necessary permissions.

killdurst

ASKER

I'm logged in as "sa" and under "Security" -> "Logins" and when I right click on "sa" and check the server roles, "sysadmin" is selected already. Am I missing anything else here?

killdurst

ASKER

Aww shucks... I'm using Management Studio Express... I think the maintenance plans are not included in this version...

harwantgrewal

Yeah you are right you need to have
Microsoft SQL Server Management Studio 9.00.1399.00

Thanks
Harry

ASKER CERTIFIED SOLUTION

killdurst

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

harwantgrewal

I am happy that you found the solution :)

Harry