Solved

Trying to schedule sql backup.

Posted on 2008-10-02
1
693 Views
Last Modified: 2012-06-27
I'm trying to setup a scheduled database backup on sql using Microsoft article 930615 as a guide.

It all works until the final step when I get the message

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

We've applied the service pack but still get the error.  Any assistance gratefully received. Thank you.
0
Comment
Question by:Petermcg001
1 Comment
 
LVL 25

Accepted Solution

by:
slam69 earned 500 total points
ID: 22622588
upgrad ethe local client tools with service pack 2 as well as the server side should solve it
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to enforce inte 8 58
execute a MS SQL script as a schedule SQL job 72 138
SQL Server 2012 express 24 40
Please help for the below sql query. 1 28
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question