database backup

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
------------------------------
LVL 1
rgb192Asked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
>> 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
 
vdr1620Commented:
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Try applying SQL Server 2005 SP3 which might help
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
rgb192Author Commented:
still have error

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

0
 
vdr1620Commented:
check your version
SELECT @@Version
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Run this:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
0
 
rgb192Author Commented:
9.00.1399.06      RTM      Enterprise Edition
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
You haven't applied SP3 and its without any Service packs..
Applying SP3 might help fix your issue..
0
 
vdr1620Commented:
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
 
lundnakCommented:
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
 
rgb192Author Commented:
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
 
vdr1620Commented:
there is a hot fix available for the problem..check the link

http://support.microsoft.com/kb/910070
0
 
rgb192Author Commented:
thanks... worked
0
All Courses

From novice to tech pro — start learning today.