Re: SV: SQL backup error.....
Then it should work...I am doing the same thing without any problems...You may need to contact Tivoli to open a problem... Thanks, Bill William Degli-Angeli IGS TDP Development Endicott, NY (607) 752-6749 TieLine: 852-6749 Internet: [EMAIL PROTECTED] Bo Nielsen Bo_Nielsen@FD To: [EMAIL PROTECTED] B.DKcc: Sent by: Subject: SV: SQL backup error. ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 08/28/2001 15:34 Please respond to ADSM: Dist Stor Manager I'm use the /TSMOPTFile parameter. Regards, Bo Nielsen -- Fra: William Degli-Angeli[SMTP:[EMAIL PROTECTED]] Svar til: ADSM: Dist Stor Manager Sendt:24. august 2001 15:01 Til: [EMAIL PROTECTED] Emne: Re: SQL backup error. Are you sure you are using the correct options (.opt) file? Try using the /TSMOPTFile to ensure you are pointing to the correct options file... Thanks, Bill William Degli-Angeli IGS TDP Development Endicott, NY (607) 752-6749 TieLine: 852-6749 Internet: [EMAIL PROTECTED] Bo Nielsen Bo_Nielsen@FD To: [EMAIL PROTECTED] B.DKcc: Sent by: Subject: SQL backup error. ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 08/24/2001 08:36 Please respond to ADSM: Dist Stor Manager Hi when I tried to run the LOGS backup I received an error message for the MASTER. In the dsm.opt file I have an exclude statement like this: exclude \...\master\...\log* but it's doesn't work. Regards, Bo Nielsen FDB dataPhone: +45 4386 4671 Roskildevej 65 Fax: +45 4386 4990 DK-2620 AlbertslundE-mail: [EMAIL PROTECTED] Denmark
SV: SQL backup error.....
I'm use the /TSMOPTFile parameter. Regards, Bo Nielsen -- Fra: William Degli-Angeli[SMTP:[EMAIL PROTECTED]] Svar til: ADSM: Dist Stor Manager Sendt:24. august 2001 15:01 Til: [EMAIL PROTECTED] Emne: Re: SQL backup error. Are you sure you are using the correct options (.opt) file? Try using the /TSMOPTFile to ensure you are pointing to the correct options file... Thanks, Bill William Degli-Angeli IGS TDP Development Endicott, NY (607) 752-6749 TieLine: 852-6749 Internet: [EMAIL PROTECTED] Bo Nielsen Bo_Nielsen@FD To: [EMAIL PROTECTED] B.DKcc: Sent by: Subject: SQL backup error. ADSM: Dist Stor Manager [EMAIL PROTECTED] IST.EDU 08/24/2001 08:36 Please respond to ADSM: Dist Stor Manager Hi when I tried to run the LOGS backup I received an error message for the MASTER. In the dsm.opt file I have an exclude statement like this: exclude \...\master\...\log* but it's doesn't work. Regards, Bo Nielsen FDB dataPhone: +45 4386 4671 Roskildevej 65 Fax: +45 4386 4990 DK-2620 AlbertslundE-mail: [EMAIL PROTECTED] Denmark
SV: SQL backup error.
Robert, thanks for the help. regards Bo -- Fra: Robert L King[SMTP:[EMAIL PROTECTED]] Svar til: ADSM: Dist Stor Manager Sendt:6. marts 2001 15:16 Til: [EMAIL PROTECTED] Emne: Re: SQL backup error. Bo, this is a known problem. From the fix's readme: This is FIXTEST Version 1.1.2.01. It includes the following fix: - IC26111 If a SQL Server 7.0 database is at compatibility level 60 or 65, an attempt to backup the database or its transaction log would result in the DB-Lib message "Incorrect syntax near the keyword 'database'" and the backup would fail. This no longer occurs. Databases at any compatibility level can now be backed up successfully. The fix is available at: ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/agent s/ntsql/1.1.2/ Bob KingIBM Global Services [EMAIL PROTECTED]