Avatar of btm02sf
btm02sf asked on

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

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.
Microsoft Server OSMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Raja Jegan R

8/22/2022 - Mon
Raja Jegan R

>> "Script Action to Job" greyed out

This means that you don't have sa privileges on the server..
Use some other login with sysadmin privileges to get it done.
ASKER
btm02sf

Thank you, rrjegan17. I figured that this could be a problem. The situation is that I can't get the software support people to do this type of stuff for me, as it is not part of their coverage, and they won't share the sa account password with me. Is there a way to create a script at the command line that would not need the sa password? If so, do you have any tips on how to create the a backup at the command line? Thanks.
ASKER CERTIFIED SOLUTION
Raja Jegan R

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
btm02sf

Understood. Thank you for your help. I will call their support line to ask them for assistance, maybe they will be willing to do a WebEx session, and log in with the sa account while I am on site, so that I can create the appropriate scheduled tasks.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Raja Jegan R

Welcome and glad to help you out..