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.
Last Comment
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
THIS SOLUTION IS 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
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..
Microsoft Server OS
The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.
59K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
This means that you don't have sa privileges on the server..
Use some other login with sysadmin privileges to get it done.