Unable to run Expressmaint

Nov 17, 2009 at 7:36 PM

Hi Everyone,

I have SQL Server Express 2005 version 8.0.760 and the newest version of ExpressMaint 2.0. I receive error when I run ExpressMaint application from console:

" Wyjątek nieobsłużony: System.IO.FileNotFoundException: Nie można załadować pliku
lub zestawu 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, Publi
cKeyToken=89845dcd8080cc91' lub jednej z jego zależności. Nie można odnaleźć okr
eślonego pliku.
Nazwa pliku: 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, Publi
cKeyToken=89845dcd8080cc91'
w ExpressMaint.ExpressMaint.Main()

OSTRZEŻENIE: rejestrowanie informacji o powiązaniach zestaww jest wyłączone.
Aby włączyć rejestrowanie błędw powiązań zestaww, ustaw wartość rejestru [HKLM\S
oftware\Microsoft\Fusion!EnableLog] (DWORD) rwną 1.
Uwaga: z włączeniem rejestrowania błędw powiązań zestaww wiąże się pewien spadek
wydajności.
Aby wyłączyć tę funkcję, usuń wartość rejestru [HKLM\Software\Microsoft\Fusion!E
nableLog]."

My command is: "G:\Aplikacje\ExpressMaint\ExpressMaint.exe -S 9fn0z0j\MSSQLSERVER -D ALL_USER -T DB -R H:\Backup\Safety\gemini\reports -RU WEEKS -RV 1 -B H:\Backup\Safety\gemini\sql -BU DAYS -BV 1 -V -C"

Previously when the application was running according to windows task scheduler I received event in system events log:

"Typ zdarzenia: Błąd
Źródło zdarzenia: .NET Runtime 2.0 Error Reporting
Kategoria zdarzenia: Brak
Identyfikator zdarzenia: 1000
Data: 2009-11-12
Godzina: 22:00:00
Użytkownik: Brak
Komputer: 9FN0Z0J
Opis:
Faulting application expressmaint.exe, version 2.0.0.0, stamp 4af5a2eb, faulting module kernel32.dll, version 5.1.2600.3541, stamp 49c4f7e4, debug? 0, fault address 0x00012a6b.
Aby znaleźć więcej informacji, zobacz http://go.microsoft.com/fwlink/events.asp w Centrum pomocy i obsługi technicznej."

ExpressMaint doesn't start, no report is generated. What can I do in such situation. Do you have any suggestions?

Coordinator
Nov 17, 2009 at 8:13 PM

Version 8.0.760 is SQL 2000. What the error is saying is you don't have SMO for SQL 2005 installed. SQL 2000 actually has its own maintenance procedures

sqlmaint http://msdn.microsoft.com/en-us/library/aa214022(SQL.80).aspx

xp_sqlmaint http://msdn.microsoft.com/en-us/library/aa260680(SQL.80).aspx

Expressmaint is for SQL 2005 or higher because these utilities are no longer present

Hope this helps

Cheers,
Jasper

 

Nov 17, 2009 at 9:22 PM

Thank you very much for your reply but I can't run this tool also. My command is: sqlmaint -S 9fn0z0j\MSSQLSERVER -U "sa" -P "password" -D Gemini -Rpt H:\Backup\Safety\gemini\reports\Gemini_maint.rpt -BkUpDb H:\Backup\Safety\gemini\sql -BkUpMedia DISK -VrfyBackup 2weeks. After that consolse display help context only. Do you know what is wrong? Please advice

Nov 18, 2009 at 4:37 PM

Please suggest me something. I'm stuck in this point. What can be done? Is there any other solution?

 

Coordinator
Nov 18, 2009 at 5:07 PM

I think it needs to be more like this however I don't have a SQL 2000 instance to try it on at the moment. You can always try the SQL newsgroups http://technet.microsoft.com/en-us/sqlserver/bb895986.aspx

sqlmaint -S 9fn0z0j\MSSQLSERVER -U sa -P password -D Gemini -Rpt H:\Backup\Safety\gemini\reports\Gemini_maint.rpt -BkUpDb H:\Backup\Safety\gemini\sql -BkUpMedia DISK -VrfyBackup -DelBkUps 2weeks

 

Nov 19, 2009 at 11:24 AM

Thanks for help. I've registered on TechNet forum but didn't receive any construstive solution. Mayby I should upgrade my SQL to the newer version. Maybe service pack must be installed? How to check if sqlmaint application connects properly with my database? Is there any diagnostic command I can use?