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.
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.
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Welcome and glad to help you out..
This means that you don't have sa privileges on the server..
Use some other login with sysadmin privileges to get it done.