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:
![0]()
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.
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:
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.
Microsoft SQL Server 2008
Last Comment
Go-Bruins
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you. I'll try this and report back.
ASKER
Thank you, one and all.
Is there another (simple) way to automatically backup an Express database?