Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Agent Job

Author  Topic 

Zoma
Yak Posting Veteran

76 Posts

Posted - 2008-10-06 : 03:31:25
Hi All
Please help! I have this client Database's i have to restore every day now and then, Now i just thought i should create a job that's going to restore. This are more like same database's but just different names, I used to basic simple way to copy the database i wnat to restore to that database then I schedule it to run every day. But i get this error massage if i run the Package.

"Could not load type 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. (Copy Database Wizard)"

Its more like it's the probolem with my SQL Agent but it is Running smoothly. pLaese HELP! Thanks!
   

- Advertisement -