Hi everybody,

we are taking full backup and transaction log backup through Maintenance Wizard on our production server(version 7.0). Till saturday(01/20/2001) we didn't face any problem through this maintenance activity. On Saturday we got the following error, (the following error we got from the sql server error log&#39

"
Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC SQLState: IM002)] Error 0:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
"

Because of the above error, we are unable to take full backup and transaction log backup on saturday & sunday. I searched through the 'Technet', I didn't get any proper information on that. When I saw the books online it says, "IM" implies, 'The class IM is specific to warnings and errors that derive from the implementation of ODBC'.

But we didn't install any ODBC Drivers or any software on that server. Now it is working fine after we reboot the server. But we want to know why such error has occured, so that we can avoid this error in future.

I appreciate if anybody explains me what is cause of this problem?.

tks in advance,
Sri