Automatic SQL Server backups

[ianclarke]

Hi

I am having a lot of difficulty setting up scheduled jobs to backup tables from Symposium. The DTS packages are running fine, when called manually, but the jobs always fail to run.

The following is the error returned:
Executed as user: NHSDW\sqladmin. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

I have checked the ODBCs on the SQL Server and they are all running perfectly.

I hope you can help.

Ian

 

[TheWorkingMan]

What are you doing? Are you using the Nortel backup utility to back up the sybase? If not, you will not be able to backup the database. The files are active and will be skipped causing failed backups. The Symposium backup utility will backup the database, keeping the server up. If you want to use some other database backup (I would never do) you must shut down the database before backup. Too much trouble, just use the SCCS backup for database.

TWM