I have created a test using ODBC Query to allow me to backup a SQL Express 2005 database using a SQL sript. The backup is performed successfully. To verify this, I have restored the database using the backed up file. The problem is, the Hostmonitor test always stays Bad, returning error "Error 1: [Microsoft][ODBC SQL][SQL Server]Processed 7072 pages for database 'VIM_VCDB', file 'VIM_VCDB' on file 1"
The SQL script I am running is BACKUP Database VIM_VCDB TO DISK = '\\ohr.adn\shares\goofybackups\goofy.bak' WITH INIT
When I perform a Check connection only, it is successful.
The SQL logs report "BACKUP failed to complete the command BACKUP DATABASE VIM_VCDB. Check the backup application log for detailed messages."
I am on Hostmonitor version 7.78, using SQL Express 2005 connecting using the ODBC SQL Server Driver. SQL authentication and the SA account
Does anyone know how I can stop the error and allow the test to be OK
Thanks. Felicia
ODBC SQL Script error
-
felicia.littlefield
- Posts: 2
- Joined: Thu Jun 09, 2005 1:34 pm