We help IT Professionals succeed at work.
Get Started

"Script Action to Job" greyed out in SQL 2008 Server Management Studio on Win 2011 SBS

8,072 Views
Last Modified: 2013-12-02
I am trying to schedule a SQL backup job for a database in SQL 2008 Server, on Windows 2011 SBS, using the SQL Server Management Studio. This is NOT the express version. I tried to follow the steps listed under KB http://support.microsoft.com/kb/930615, but the option Script Action to Job is greyed out (Step 8) in the article mentioned above.
I am logged into the server using Windows Authentication, because the database is proprietary (Dolphin from Dolphin Imaging - software used by orthodontists). I was not given the sa account password by the support group at Dolphin Imaging.
I can execute a full manual backup, but I would like to schedule the backup so it happens automatically at night.
Any feedback would be much appreciated. Thank you.
Comment
Watch Question
SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE