ILCattivo
ADSM.ORG Senior Member
According to the IBM Hardware and Software requirements article for the TSM TDP for SQL v 7.1.3 the following SQL versions are supported.
X86
MS SQL Server 2008 SP3 and later
MS SQL Server 2008 R2 SP2 and later
Standard, Enterprise & Data Center Editions
X64
MS SQL Server 2008 SP3 and later
MS SQL Server 2008 R2 SP2 and later
Standard, Enterprise & Data Center Editions
When I run the SQL backups manually or via a scheduler I get the following error message within both sqllog.log & sqlsched.log
Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Its as if it keeps requiring something from SQL Server 2012 maybe?
Any ideas how I can get round this or fix it?
NB:// The TDP version was recently upgraded from 6.4.1 to 7.1.3 and has not worked since! Reverting back is not an option as 6.4.1 seemed to refuse to send it's RC= codes back to TSM and thus all backups reported as failed even though they actually weren't...
Many Thanks
cmd that's being called is below..
set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql
C:
cd %sql_dir%
rem ==================================================================
rem The two lines below put a date/time stamp in a log file for you.
rem Note: You can change "sqlsched.log" to whatever you prefer in
rem lines below.
rem ==================================================================
date /t < NUL >> %sql_dir%\sqlsched.log
time /t < NUL >> %sql_dir%\sqlsched.log
rem ==================================================================
rem Now call the command-line interface to do the backup:
rem
rem Replace "srvrname" with the name of the options file name you
rem plan to use.
rem
rem If SQL authentication is being used and the SQL login settings have
rem not been stored via the GUI, you must also specify the /sqluser and
rem /sqlpassword options on the command below.
rem
rem In this example, we use the '*' to back up all of the databases
rem on the SQL server. Note that database 'tempdb' will not
rem be backed up.
rem
rem Note: You can change "sqlsched.log" and "sqlfull.log" to
rem whatever you prefer.
rem ==================================================================
%sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlsched.log
set RC=%ERRORLEVEL%
echo --------------------- >> %sql_dir%\sqlsched.log
echo Return code was %RC% >> %sql_dir%\sqlsched.log
echo ===================== >> %sql_dir%\sqlsched.log
exit %RC%
X86
MS SQL Server 2008 SP3 and later
MS SQL Server 2008 R2 SP2 and later
Standard, Enterprise & Data Center Editions
X64
MS SQL Server 2008 SP3 and later
MS SQL Server 2008 R2 SP2 and later
Standard, Enterprise & Data Center Editions
When I run the SQL backups manually or via a scheduler I get the following error message within both sqllog.log & sqlsched.log
Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Its as if it keeps requiring something from SQL Server 2012 maybe?
Any ideas how I can get round this or fix it?
NB:// The TDP version was recently upgraded from 6.4.1 to 7.1.3 and has not worked since! Reverting back is not an option as 6.4.1 seemed to refuse to send it's RC= codes back to TSM and thus all backups reported as failed even though they actually weren't...
Many Thanks
cmd that's being called is below..
set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql
C:
cd %sql_dir%
rem ==================================================================
rem The two lines below put a date/time stamp in a log file for you.
rem Note: You can change "sqlsched.log" to whatever you prefer in
rem lines below.
rem ==================================================================
date /t < NUL >> %sql_dir%\sqlsched.log
time /t < NUL >> %sql_dir%\sqlsched.log
rem ==================================================================
rem Now call the command-line interface to do the backup:
rem
rem Replace "srvrname" with the name of the options file name you
rem plan to use.
rem
rem If SQL authentication is being used and the SQL login settings have
rem not been stored via the GUI, you must also specify the /sqluser and
rem /sqlpassword options on the command below.
rem
rem In this example, we use the '*' to back up all of the databases
rem on the SQL server. Note that database 'tempdb' will not
rem be backed up.
rem
rem Note: You can change "sqlsched.log" and "sqlfull.log" to
rem whatever you prefer.
rem ==================================================================
%sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlsched.log
set RC=%ERRORLEVEL%
echo --------------------- >> %sql_dir%\sqlsched.log
echo Return code was %RC% >> %sql_dir%\sqlsched.log
echo ===================== >> %sql_dir%\sqlsched.log
exit %RC%