?
Solved

database backup

Posted on 2010-08-25
13
Medium Priority
?
586 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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
 
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 2000 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

741 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