Solved

database backup

Posted on 2010-08-25
13
566 Views
Last Modified: 2012-05-10
I am trying to create maintenance plan automatic 1 database backup
I got this error

TITLE: Maintenance Plan Wizard Progress
------------------------------

Create maintenance plan failed.

------------------------------
ADDITIONAL INFORMATION:

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

------------------------------
BUTTONS:

OK
------------------------------
0
Comment
Question by:rgb192
  • 4
  • 4
  • 4
  • +1
13 Comments
 
LVL 16

Expert Comment

by:vdr1620
ID: 33521873
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33521995
Try applying SQL Server 2005 SP3 which might help
0
 

Author Comment

by:rgb192
ID: 33522103
still have error

i installed sp3
which required no restart
how can i tell that sp3 is installed

0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33522185
check your version
SELECT @@Version
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33522207
Run this:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
0
 

Author Comment

by:rgb192
ID: 33522378
9.00.1399.06      RTM      Enterprise Edition
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33522394
You haven't applied SP3 and its without any Service packs..
Applying SP3 might help fix your issue..
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33522691
you would have seen something like .. Microsoft SQL Server 2005 (SP3) .........
when you run select @@Version...

OR

9.00.1399.06      SP3     Enterprise Edition

which will show that you have installed a service pack.. instead of RTM

0
 
LVL 7

Expert Comment

by:lundnak
ID: 33524443
What are the results of this query?

select serverproperty('ProductVersion'),serverproperty('ResourceVersion')

The ProductVersion property references the level that the executables are patched to.  This is the same results as @@Version.

The ResourceVersion property references the level that the master and systemresource (hidden database) databases are patched to.

I've had cases where these two are different.  The best fix is always to re-apply any patches or service packs.
0
 

Author Comment

by:rgb192
ID: 33524463
I am installing sp3 to sql server 2005 on windows server 2008

and stops at this for one hour
installing windows installer file sqlrun_tools.msp

what should I do
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33524519
there is a hot fix available for the problem..check the link

http://support.microsoft.com/kb/910070
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 33528696
>> and stops at this for one hour

do you have any major application running in your server..
Do make sure that SQL Server is not accessed by any applications while you are applying SP3.
0
 

Author Closing Comment

by:rgb192
ID: 33532934
thanks... worked
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now