1

Resolved

Can not backup WSUS SQL Express instance

description

I've been trying unsucessfully to backup a WSUS SQL Express instance via the following cmd: "C:\Program Files\Microsoft SQL Server\ExpressMaint.exe" -S SOCRATES-MON\MICROSOFT##SSEE -D ALL -T DB -B c:\backup -BU DAYS -BV 3 -V
 
I am getting the following error in the event log:
Event Type: Error
Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 1000
Date: 21/05/2008
Time: 10:27:41 p.m.
User: N/A
Computer: SOCRATES-MON
Description:
Faulting application expressmaint.exe, version 1.4.0.0, stamp 44945c8c, faulting module kernel32.dll, version 5.2.3790.4062, stamp 46264680, debug? 0, fault address 0x0000bee7.
 
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
0008: 69 00 63 00 61 00 74 00 i.c.a.t.
0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
0020: 75 00 72 00 65 00 20 00 u.r.e. .
0028: 20 00 65 00 78 00 70 00 .e.x.p.
0030: 72 00 65 00 73 00 73 00 r.e.s.s.
0038: 6d 00 61 00 69 00 6e 00 m.a.i.n.
0040: 74 00 2e 00 65 00 78 00 t...e.x.
0048: 65 00 20 00 31 00 2e 00 e. .1...
0050: 34 00 2e 00 30 00 2e 00 4...0...
0058: 30 00 20 00 34 00 34 00 0. .4.4.
0060: 39 00 34 00 35 00 63 00 9.4.5.c.
0068: 38 00 63 00 20 00 69 00 8.c. .i.
0070: 6e 00 20 00 6b 00 65 00 n. .k.e.
0078: 72 00 6e 00 65 00 6c 00 r.n.e.l.
0080: 33 00 32 00 2e 00 64 00 3.2...d.
0088: 6c 00 6c 00 20 00 35 00 l.l. .5.
0090: 2e 00 32 00 2e 00 33 00 ..2...3.
0098: 37 00 39 00 30 00 2e 00 7.9.0...
00a0: 34 00 30 00 36 00 32 00 4.0.6.2.
00a8: 20 00 34 00 36 00 32 00 .4.6.2.
00b0: 36 00 34 00 36 00 38 00 6.4.6.8.
00b8: 30 00 20 00 66 00 44 00 0. .f.D.
00c0: 65 00 62 00 75 00 67 00 e.b.u.g.
00c8: 20 00 30 00 20 00 61 00 .0. .a.
00d0: 74 00 20 00 6f 00 66 00 t. .o.f.
00d8: 66 00 73 00 65 00 74 00 f.s.e.t.
00e0: 20 00 30 00 30 00 30 00 .0.0.0.
00e8: 30 00 62 00 65 00 65 00 0.b.e.e.
00f0: 37 00 0d 00 0a 00 7.....
 
Please advise what the issue is, thanks.

comments

jaspersmith wrote Jun 4, 2008 at 11:02 PM

The Windows Internal Databases does not seem to install SMO which is required by Expressmaint. You can download the standalone SMO redistributable from the following link
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

(Scroll down the page to Microsoft SQL Server 2005 Management Objects Collection - note that it has a couple of dependencies that also need to be downloaded - Microsoft Core XML Services (MSXML) 6.0 and Microsoft SQL Server Native Client, also available on this page)

RichParkie wrote Jun 10, 2008 at 4:53 AM

Thanks Jasper,

Reinstalling SMO & the native client sorted my issue & SQL Express backing up fine now.