Solved

database backup

Posted on 2010-08-25
13
579 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

733 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