Link to home
Create AccountLog in
Avatar of Go-Bruins
Go-Bruins

asked on

SQL 2008 Express R2 automatic backup

Hi all,

I have SQL Server 2008 Express with Management Studio installed on my machine running a Microsoft BCM database.

I'd like to do automatic backups every day to a local drive.

From searching around in EE, it appears i need to have SQL Server Agent running to do this. When i try to enable this service, i get the following error:

User generated image
When i try to start this service in Task Manager, i get "The operation could not be completed. Access is denied."

What am i doing wrong? Thanks in advance.
SOLUTION
Avatar of Nakul Vachhrajani
Nakul Vachhrajani
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Go-Bruins
Go-Bruins

ASKER

Darnit - too bad.

Is there another (simple) way to automatically backup an Express database?
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thank you. I'll try this and report back.
Thank you, one and all.