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.