SQL 2005 Backup Schedule Error

Question

 

Hi,

 

I want to schedule a daily backup of one of my database in SQL 2005 Enterprise edtion but

the problem is, I can't save my job. Please help, here's the error.

 

===================================

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.Agent.JobCollection.GetObjectByKey(ObjectKeyBase key)
   at Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase.Contains(String name)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobData.JobExists(String jobName)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobData.ApplyChanges()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobPropertySheet.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)
   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType)
   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)

 

Thanks.

 

Russell

Answer 1

What is the Service pack for sql server 2005 ? if youhave not applied SP2 with critical update pls apply the same and try. Also pls refer, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2094755&SiteID=1&pageid=1 check if it helps

- Deepak